create index x11 on table1 (id,col1);
create index x12 on table1 (id,col2);
create index x21 on table2 (id,col1);
create index x22 on table2 (id,col2);
create index x31 on table3 (id,col1);
create index x32 on table3 (id,col2);
select table1.col1,table1.col2,
table2.col11,table2.col22,
table3.col31,table1.col23
from table1 ,table2,table3
where table1.id=table2.id and table2.id2=table3.id2
and ...
表A的 ID,NUMBER,PRICE,ORDER_TIME,STATUS
表B的 USER_ID,STARTIME,STOPTIME,
表C的 CHANNEL_PAY
表D的 COMPANY
其中表A的COMPANY_ID=表B的COMPANY_ID=表C的 COMPANY_ID=表D的UID
SELECT
A.ID,
A.NUMBER,
A.PRICE,
A.ORDER_TIME,
B.USER_ID,
B.STARTIME,
B.STOPTIME,
C.CHANNEL_PAY,
D.COMPANY
FROM
D表 D
LEFT JOIN A表 A ON A.COMPANY_ID = D.UID
LEFT JOIN B表 B ON B.COMPANY_ID = D.UID
LEFT JOIN C表 C ON C.COMPANY_ID = D.UID
有条件的再加行:
WHERE ..........
排序(如A表的ID由大到小排):
ORDER BY A.ID DESC