语句如下： SELECT A.* from A ,B,C WHERE A.COL_A = B.COL_B1 AND B.COL_B2 = C.COL_C
SELECT A.* from A JOIN (B JOIN C ON (B.COL_B2 = C.COL_C)) ON (A.COL_A = B.COL_B1)
SELECT A.* from (A JOIN B ON A.COL_A = B.COL_B1) JOIN C ON B.COL_B2 = C.COL_C
怎么不能上传图片？SELECT /*+ ORDERED*/ A.COL1,B.COL2,C.COL3 from TABLE1 A,TABLE2 B,TABLE3 C WHERE A.A.COL_A=B.COL_B1 AND B.COL_B2 = C.COL_C; 建议用临时表查询。我和你的问题差不多，就是用临时表解决的。
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 上面一个简单的SQL,执行时间2.6� ......
