sql not exist

最新推荐文章于 2024-06-01 15:59:22 发布

虫来

最新推荐文章于 2024-06-01 15:59:22 发布

阅读量81

点赞数

本文链接：https://blog.csdn.net/huyuantai000/article/details/88331963

版权

SELECT DISTINCT T_CINEMA.CINEMA_ENTITY_ID,T_CINEMA.CINEMA_NAME
                       FROM T_CINEMA,T_GROUP_CINEMA
                       WHERE
                       NOT EXISTS
                      (
                           SELECT null FROM T_GROUP_CINEMA
                           where T_GROUP_CINEMA.CINEMA_ENTITY_ID=T_CINEMA.CINEMA_ENTITY_ID
                      );

                       SELECT DISTINCT T_CINEMA.CINEMA_ENTITY_ID,T_CINEMA.CINEMA_NAME
                       FROM T_CINEMA,T_GROUP_CINEMA
                       WHERE
                       T_CINEMA.CINEMA_ENTITY_ID not in(SELECT CINEMA_ENTITY_ID FROM T_GROUP_CINEMA);

当T_GROUP_CINEMA表没数据依然可以查询出数据来

select T_CINEMA.CINEMA_ENTITY_ID,T_CINEMA.CINEMA_NAME
from T_CINEMA
where not exists (select 1 from T_GROUP_CINEMA where T_GROUP_CINEMA.CINEMA_ENTITY_ID=T_CINEMA.CINEMA_ENTITY_ID )