如何在a,b,c三张表中查一条记录'1'?他们有相同的字段code

[gan_lg]

如何在a,b,c三张表中查一条记录'1'?他们有相同的字段code

[-狙击手-]

select aa.* from (select code from a union select code from b union select code from c)
as aa where code = '1'

[-狙击手-]

declare @t table([code] int)
declare @t1 table([code] int)
declare @t2 table([code] int)
insert @t select 1 union select 2
insert @t1 select 11 union select 12
insert @t2 select 21 union select 22
select * from
(select code from @t
union
select code from @t1
union
select code from @t2) a
where a.code = 1


/*
code
-----------
1

*/