34,587
社区成员
发帖
与我相关
我的任务
分享
--测试语句
if object_id[Basic] drop table [Basic]
create table [Basic](int k,pk varchar(20),content varchar(100))
insert [Basic] select 1,'',''
union all 2,'',''
union all 3,'',''
--查询
SELECT * FROM Basic,Func WHERE Basic.k = Func.k
----------------------------
--测试语句
if object_id[Func] drop table [Func]
create table [Func](int k,fk varchar(20),compact varchar(100))
insert [Basic] select 1,'',''
union all 2,'',''
union all 3,'',''
--执行查询
SELECT * FROM Basic RIGHT JOIN Func ON Basic.k = Func.k
分析执行计划相同