sql取得不包含某数据的字段。。。not in

来源:互联网 发布:java语言入门培训班 编辑:程序博客网 时间:2024/06/04 20:05
SELECT g.GroupId as '群组编号', g.GroupName as '群组名称'from groupmain as gWHERE g.GroupID NOT IN (SELECT p.GroupID from phonebook as p WHERE p.GroupID is not NULL)

0 0