语法规则:
SELECT * FROM tableName t WHERE 1 = 1 AND 2 = 2 AND EXISTS (SELECT * FROM tableName t2 WHERE t.id = t2.proj_id)
SELECT * FROM tableName t WHERE 1 = 1 AND 2 = 2 AND NOT EXISTS (SELECT * FROM tableName t2 WHERE t.id = t2.proj_id)
内容来源于网络如有侵权请私信删除
- 还没有人评论,欢迎说说您的想法!