语法规则:
 
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)

 

内容来源于网络如有侵权请私信删除
你还没有登录,请先登录注册
  • 还没有人评论,欢迎说说您的想法!