可以。这样看看 select x.e1, y.e2 from (select tblC.e e1 as e1 from tblC where tblC.pk= (select tblB.c as c from tblA,tblB where tblA.X='x' and tblA.X=tblB.X)) x, (select tblC.e e2 as e2 from tblC where tblC.pk= (select tblB.d as d from tblA,tblB where tblA.X='x' and tblA.X=tblB.X)) y
select a.e from (select tblA.a as a , tblB.b as b, tblB.c as c, tblB.d as d from tblA,tblB where tblA.X='x' and tblA.X=tblB.X) a, tblC b where a.c=b.pk and a.d = b.pk
select tblA.a as a , tblB.b as b, tblB.c as c, tblB.d as d, tblC1.e as e1, tblC2.e as e2 from tblA,tblB,tblC tblC1,tblC tblC2 where tblA.X='x' and tblA.X=tblB.X and tblC1.pk=tblB.c and tblC2.pk=tblB.d
select x.e1, y.e2
from (select tblC.e e1 as e1 from tblC where tblC.pk= (select tblB.c as c from tblA,tblB where tblA.X='x' and tblA.X=tblB.X)) x,
(select tblC.e e2 as e2 from tblC where tblC.pk= (select tblB.d as d from tblA,tblB where tblA.X='x' and tblA.X=tblB.X)) y
tblA.a as a ,
tblB.b as b,
tblB.c as c,
tblB.d as d
from tblA,tblB where tblA.X='x' and tblA.X=tblB.X) a,
tblC b where a.c=b.pk and a.d = b.pk
tblA.a as a ,
tblB.b as b,
tblB.c as c,
tblB.d as d,
tblC1.e as e1,
tblC2.e as e2
from tblA,tblB,tblC tblC1,tblC tblC2
where tblA.X='x' and tblA.X=tblB.X
and tblC1.pk=tblB.c
and tblC2.pk=tblB.d