select a.aa,b.name,c.name from 主表 a,子表1 b,子表2 c where a.bb=b.bb and a.cc=c.cc
CREATE table t (bb varchar(100),cc varchar(100)) Insert t(bb, cc) Select bb, cc from 主表 update t set bb=a.name, cc=b.name from 子表1 a, 子表2 b, t c where c.bb = a.bb and c.cc = a.cc
select a.aa,isnull(b.name,'') nameb,isnull(c.name,'') namec from 主表 a left join 子表1 b on a.bb=b.bb left join 子表2 c on a.cc=c.cc
select a.aa,b.name as bname,c.name as cname from a left outer join b on a.bb=b.bb left outer join c on a.cc=c.cc
select aa,b.bname,c.cname from a,b,c where a.bb=b.bb and a.cc=c.cc
select a.aa,b.name as name1,c.name as name2 from a inner join b on a.bb=b.bb inner join c on a.cc=c.cc 建议兄弟你在SQL企业管理器里面建立视图,就不用写语句了.比较适合初学者
select aa,b.bname,c.cname from a,b,c where a.bb=b.bb and a.cc=c.cc
from 主表 a,子表1 b,子表2 c
where a.bb=b.bb and a.cc=c.cc
Insert t(bb, cc) Select bb, cc from 主表
update t set bb=a.name, cc=b.name from 子表1 a, 子表2 b, t c
where c.bb = a.bb and c.cc = a.cc
from 主表 a
left join 子表1 b on a.bb=b.bb
left join 子表2 c on a.cc=c.cc
from a left outer join b on a.bb=b.bb left outer join c on a.cc=c.cc
from a
inner join b on a.bb=b.bb
inner join c on a.cc=c.cc
建议兄弟你在SQL企业管理器里面建立视图,就不用写语句了.比较适合初学者