select IN_ORDER_CODE,BUDDY_NAME,plan_emp,h.MODIFY_TIME,
CAR_NUMBER,BOX_SIZE,PLAN_WORKLOAD,PLAN_PIECENUM,
pos_name as plan_allocation_name,
stock_name as stockName,
buddy_name as scraper_name
from IMS_STOCK_TEAM_INFO stock,IMS_COLD_STORAGE_HEAD h
left join
ims_stock_pos_info as sp,
vi_ims_stock_info as v,
dms_buddy_info as dbiscraper
on
sp.pk_id = stock.PLAN_ALLOCATION,
v.pk_id = h.RECEIVE_WARE_HOUSE,
dbiscraper.pk_id = stock.scraper
WHERE stock.comp_pkid='tieyue' AND stock.head_pkid='c7de39a4-51d4-4c61-811e-00aa877cf602'
uj5u.com熱心網友回復：
是我寫sql的格式出問題了？？uj5u.com熱心網友回復：
left join ims_stock_pos_info as sp, vi_ims_stock_info as v, dms_buddy_info as dbiscraperon sp.pk_id = stock.PLAN_ALLOCATION, v.pk_id = h.RECEIVE_WARE_HOUSE,
每個 left join 要分開寫
select * from a
left join b on a.id = b.id
left join c on a.id = c.id
uj5u.com熱心網友回復：
樓上正解........uj5u.com熱心網友回復：
一個join只能添加一張表。uj5u.com熱心網友回復：
你這么寫外連接要看死個人哦
uj5u.com熱心網友回復：
oracle資料庫的多表連接查詢和Mysql有區別， Oracle連接每一張表都需要必須要left join，而MySql多張表 一個left join 后表間用逗號隔開。uj5u.com熱心網友回復：
樓上說的很對了，需要多表關聯查詢，用到join的，必須一張一張的join，比如A,B,C三張表，都用ID欄位來做左連接關聯，必須是A LEFT JOIN B ON A.ID=B.ID LEFT JOIN C ON A.ID=C.ID轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/63567.html
標籤：開發