mysql多個(gè)查詢條件,MYSQL多表聯(lián)合查詢?
SELECTA.ID,A.NUMBER,A.PRICE,A.ORDER_TIME,B.USER_ID,B.STARTIME,B.STOPTIME,C.CHANNEL_PAY,D.COMPANYFROMD表DLEFTJOINA表AONA.COMPANY_ID=D.UIDLEFTJOINB表BONB.COMPANY_ID=D.UIDLEFTJOINC表CONC.COMPANY_ID=D.UID有條件的再加行:WHERE..........排序(如A表的ID由大到小排)
:ORDERBYA.IDDESC