create view ABC as select a.name as AName, a.age as AAge, a.address as AAddress, b.name as BName, b.age as BAge, b.address as BAddress, c.name as CName, c.age as CAge, c.address as CAddress from A,B,C go select * from ABC 亲自试验,不敢造假啊!!!
三张表有关联吗? 可以这样查 select * from A,B,C;
(select * from a) union all (select * from b) union all (select * from c)
as
select a.name as AName, a.age as AAge, a.address as AAddress,
b.name as BName, b.age as BAge, b.address as BAddress,
c.name as CName, c.age as CAge, c.address as CAddress
from A,B,C
go
select * from ABC
亲自试验,不敢造假啊!!!
union all
(select * from b)
union all
(select * from c)