MYSQL多表联合查询

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