select a.ttc,convert(a.oilgunno,SIGNED) as oilgunno,
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,
還有C表還要 左連接和 a 表，應該怎么樣，謝謝
uj5u.com熱心網友回復：
就是3個表的左連接uj5u.com熱心網友回復：
和 left join b 一樣，加在后面就行uj5u.com熱心網友回復：
在后面加就行了，on 的條件給a表的條件就OK了uj5u.com熱心網友回復：
select a.ttc,convert(a.oilgunno,SIGNED) as oilgunno,
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno
LEFT JOIN C表 c ON a.XXX = c.XXX
uj5u.com熱心網友回復：
LEFT JOIN C ON C.oilno=A.oilno
uj5u.com熱心網友回復：
select a.ttc,convert(a.oilgunno,SIGNED) as oilgunno,
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,
LEFT JOIN 第三個表 c ON a.oilno = c.oilno
uj5u.com熱心網友回復：
select a.ttc,convert(a.oilgunno,SIGNED) as oilgunno,a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,
LEFT JOIN c on a.oilno=c.oilno
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/103739.html
標籤：MySQL