SELECTA.ID,A.NUMBER,A.PRICE,A.ORDER_TIME,B.USER_ID,B.STARTIME,B.STOPTIME,C.CHANNEL_PAY,PANYFROMD表DLEFTJOINA表PANY_ID=D.UIDLEFTJOINB表PANY_ID=D.UIDLEFTJOINC表PANY_ID=D.UID有条件的再加行:WHERE……….排序(如A表的ID由大到小排)
:ORDERBYA.IDDESC
时间:2019-12-22 13:08:57
SELECTA.ID,A.NUMBER,A.PRICE,A.ORDER_TIME,B.USER_ID,B.STARTIME,B.STOPTIME,C.CHANNEL_PAY,PANYFROMD表DLEFTJOINA表PANY_ID=D.UIDLEFTJOINB表PANY_ID=D.UIDLEFTJOINC表PANY_ID=D.UID有条件的再加行:WHERE……….排序(如A表的ID由大到小排)
:ORDERBYA.IDDESC