我有以下幾點Accounts_Users table：
account_id | user_id
--------------------
1 | 60
2 | 60
3 | 60
1 | 50
3 | 50
3 | 40
我想檢索所有user_id's沒有特定行的資料account_id例如如果 account_id = 2 我想要的結果應該是：
user_id
-------
50
40
Since user_id = 60 have record with account = 2.
我怎樣才能使用子查詢或以任何其他方式做到這一點？
uj5u.com熱心網友回復：
您使用子查詢：
select distinct user_id
from Accounts_Users
where user_id not in (
select user_id from Accounts_Users where account_id = 2
)
uj5u.com熱心網友回復：
子查詢方式：
select distinct user_id
from accounts_users
where user_id not in (
select user_id
from accounts_users
where account_id = 2)
加盟方式：
select distinct a.user_id
from accounts_users a
left join accounts_users b on b.user_id = a.user_id
and b.account_id = 2
where b.user_id is null
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/362593.html