在执行左联接之前,我正在寻找一种排除某些记录的方法。
我的sql语句如下所示:
SELECT * FROM users
LEFT JOIN (SELECT * FROM premissions WHERE post_id = 1) AS p
ON p.user_id = users.id
WHERE p.id IS NULL如何排除用户表中id 1和2的记录?
发布于 2014-05-29 21:44:57
可以将条件添加到WHERE子句中:
SELECT *
FROM users
LEFT JOIN ( SELECT *
FROM premissions
WHERE post_id = 1
) AS p
ON p.user_id = users.id
WHERE p.id IS NULL
AND users.id NOT IN (1,2)发布于 2014-05-29 21:44:05
使用子选择
SELECT * FROM
(select * from users where id not in(1,2))
u
LEFT JOIN (SELECT * FROM premissions WHERE post_id = 1) AS p
ON p.user_id = u.id
WHERE p.id IS NULL发布于 2014-05-29 21:44:59
SELECT * FROM
(select from users where id not in (1,2)) u
LEFT JOIN (SELECT * FROM premissions WHERE post_id = 1) AS p
ON p.user_id = u.id
WHERE p.id IS NULLhttps://stackoverflow.com/questions/23943513
复制相似问题