查询问题

[liyuyu]

共3个表（A表，B表，C表）
A表三个字段（A1,A2,A3)
B表三个字段(B1,B2,B3)
C表三个字段(C1,C2,C3)

查询 select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3//列出满足条件A.A1,B.B1
我想要上面查询结果A.A1与C表中C.C1比较，相同的同上面一起列出来，如何写。


非常谢谢

[青锋-SS]

select * from c,(select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3) t where c.c1=t.a1

[wzy_love_sly]

select 字段，字段 from (
select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3)tp
join c on tp.a1=c.c1

[yrwx001]

select D.*,C1 from (select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3)D,C WHERE D.A1 = C.C1

[nzperfect]

select A.A1,B.B1,C.C1 from A,B,C where A.A2=B.B2 and A.A3=B.B3 AND A.A1=C.C1
这个意思?

[wzy_love_sly]

c表要什么字段？


select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3)tp
union all
select 字段，字段 from (
select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3)tp
join c on tp.a1=c.c1

[青锋-SS]

--这样也可以
select A.A1,c.* 
from A,B,c 
where A.A2=B.B2 and A.A3=B.B3 and a.a1=c.c1

[nzperfect]

你们为什么非要把
select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3
当成一个表咧?

[csshan]

select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3
left join
select A.A1,C.C1 from A,C where A.A2=C.C2 and A.A3=C.C3

[wzy_love_sly]

相同的同上面一起列出来
---
要union all

[csshan]

select a.*,C1 from (select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3)a,C WHERE a.A1 = C.C1

[青锋-SS]

select A.A1,B.B1 from A,B where A.A2=B.B2 and A.A3=B.B3
union all select A.A1,c.c1 from A,c where A.A1=c.c1

[liyuyu]

谢谢各位