[Quote=引用 2 楼 gyc1105 的回复:]
Select A.A1,A.A2,A.A3,B.B2,B.B3,C.C2 from A inner jion B on A.B2 = B.B2 inner jion C on b.C3 = C.C3
用inner jion 就可以解决问题
[/Quote]
[Quote=引用 2 楼 gyc1105 的回复:]
Select A.A1,A.A2,A.A3,B.B2,B.B3,C.C2 from A inner jion B on A.B2 = B.B2 inner jion C on b.C3 = C.C3
用inner jion 就可以解决问题
[/Quote]
这种没问题。好像这样也对:
select a.A1,a.A2,a.A3,b.B2,b.B3,c.C2 from A a,B b,C c where a.B2=b.B2 and b.C3=c.C3