select t1.v2,t1.v3,t1.v4,t2.m2,t2.m3,t2.m4,t3.n2,t5.o2,t5.o3,t6.t2 from t1,t2,t3,t4,t5,t6 where t4.o1=t5.o1 and t4.k1=t2.k1 and t1.m1=t2.m1 and t2.n1=t3.n1
to楼主:哪个是住表呀?否则很难出来数据的。tosmile13() : ------------------------> select t1.v2,t1.v3,t1.v4,t2.m2,t2.m3,t2.m4,t3.n2,t5.o2,t5.o3,t6.t2 from t1,t2,t3,t4,t5,t6 where t4.o1=t5.o1 and t4.k1=t2.k1 and t1.m1=t2.m1 and t2.n1=t3.n1 ------------------------< sql关联成这样太那个了吧!逻辑混乱啊。
把你用 join 做出来的句子贴出来看下啊~
------------------------>
select t1.v2,t1.v3,t1.v4,t2.m2,t2.m3,t2.m4,t3.n2,t5.o2,t5.o3,t6.t2 from t1,t2,t3,t4,t5,t6 where t4.o1=t5.o1 and t4.k1=t2.k1 and t1.m1=t2.m1 and t2.n1=t3.n1
------------------------<
sql关联成这样太那个了吧!逻辑混乱啊。