基础的问题
drop table a
drop table b
drop table c
go
create table a (id int)
insert into a
select 1 union
select 2 union
select 3 union
select 4 union
select 5
create table b(id int,name int)
insert into b
select 1,11 union
select 2,22 union
select 13,33 union
select 14,44 union
select 15,55
create table c(name int)
insert into c
select 11 union
select 23 union
select 133 union
select 144 union
select 155
select *
from (select a.id
from a join b on a.id=b.id
join c on b.name=c.name ) d
这个语句为什么在查询分析器中没返回结果呢,只是提示命令完成
不是有select *
from 这语句吗?