sql关联查询一个例子

最新推荐文章于 2020-06-21 14:34:22 发布

路易斯睿齐

最新推荐文章于 2020-06-21 14:34:22 发布

阅读量468

点赞数

分类专栏： sql 文章标签： select sql

本文链接：https://blog.csdn.net/RichieZhu/article/details/52228534

版权

sql 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

文字版：

select * from test01,test02 where test01.myname=test02.myname 
--select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='test02')

select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='test01') 
and name not in(select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name='test02'))
select * from test01 where not exists(select * from test02 where test01.myname=test02.myname)
select * from test01 where (select count(1) as num from test02 where test01.myname=test02.myname) = 0
--select * from test01 left join test02 on  test01.myname=test02.myname 
select * from test01 left join test02 on test01.myname=test02.myname  where test02.myname is null