|
楼主 |
发表于 2018-6-25 17:28:14
|
显示全部楼层
SELECT b.contract_id ,b.total_money, b.contract_id AS id , b.contract_no , b.contract_type , b.sign_date , b.saler , b.buyer , a.invoice_title , b.invoice_duty , b.invoice_address , b.invoice_phone , b.invoice_openingback , a.return_stage , d.sName , a.gmt_create FROM d_invoice_info a RIGHT JOIN d_contract_info b ON a.contract_id = b.contract_id AND b. STATUS = 1 LEFT JOIN d_construction_msg c ON c.contract_id = a.contract_id AND c. STATUS = 1 LEFT JOIN sa_opperson d ON d.sId = a.create_id WHERE a. STATUS = 1 and ( (b.sign_date > StringToDateTime('2017-12-25 16:56:56')) ) ORDER BY a.gmt_create desc limit 0,20, binds: []出错
|
|