SELECT id,name FROM tb_category WHERE (id = 11) OR (id = (SELECT fid FROM tb_category AS b_category_1 WHERE (id = 322))) AND (fid = 11) OR (id = 322) 我想要的是 第一页显示的是id 322的那个,不要316的。
...全文
1908打赏收藏
帮改个Sql语句问题,谢谢
SELECT id,name FROM tb_category WHERE (id = 11) OR (id = (SELECT fid FROM tb_category AS b_category_1 WHERE (id = 322))) AND (fid = 11) OR (id = 322) 我想要的是 第一页显示的是id 322的那个,不要316的。
SELECT id,name
FROM tb_category
WHERE id = 11
OR id = (SELECT fid FROM tb_category AS b_category_1 WHERE id = 322)
AND fid = 11
OR id = 322
只给你把语句简化了一下,你先自己看清楚这个逻辑对不对,AND和OR不加括号混用是本意吗
SELECT id,name FROM tb_category WHERE
(id = 11) OR
(
id = (
SELECT fid FROM tb_category AS b_category_1 WHERE (id = 322)
)
AND (fid = 11))
OR (id = 322)