求助Select语句如何实现多表查询

[chengduforest]

有两个表：TableA、TableB，他们分别含有两个字段Field1，Field2，如何用Select语句实现从两个表中获取Field1，Field2两个列，去掉重复的Field1+Field2

[lovvver]

select distinct Field1,Field2 from (select Field1,Field2 from TableA union all select Field1,Field2 from TableB)a

[ljhkim6]

select A.f1,A.f2,B.f1,B.f2 from TableA as A
inner join TableB as B
on A.id=B.id