The select IN_ORDER_CODE, BUDDY_NAME plan_emp, h.M ODIFY_TIME,
CAR_NUMBER BOX_SIZE, PLAN_WORKLOAD PLAN_PIECENUM,
Pos_name as plan_allocation_name,
Stock_name as stockName,
Buddy_name as scraper_name
The from IMS_STOCK_TEAM_INFO stock, IMS_COLD_STORAGE_HEAD h
Left the 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,
Valerie plame k_id=practice ECEIVE_WARE_HOUSE,
Dbiscraper. Pk_id=stock. Scraper
WHERE stock.com p_pkid='tieyue AND stock. Head_pkid=' c7de39a4-51 c61 d4-4-811-00 aa877cf602 e '

CodePudding user response:

I wrote something wrong with the format of the SQL??

CodePudding user response:

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, Valerie plame k_id=practice ECEIVE_WARE_HOUSE,

Each left the join to separate write

Select * from a
Left the join b on Anderson, d=b.i d
Left the join on Anderson, d=c.i d c

CodePudding user response:

Upstairs truth...

CodePudding user response:

A join can only add one table,

CodePudding user response:

you write is the outer join KanSi personal oh so

CodePudding user response:

Multi-table connection of oracle database query and Mysql have distinction, oracle connection each table needs must be left the join, and Mysql form a left after the join between tables to use commas,

CodePudding user response:

Upstairs said is very right, need more than A table query, use the join, and must be A piece of A join, such as A, B, C three tables, LEFT the connection ID field is used to do, must be A LEFT join B ON Anderson, D=B.I D LEFT join ON Anderson, D=C.I D C