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'
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'
解决方案 »
- 求oralce问题,出现指定项与恢复目录中的任何归档日志均不匹配
- 关于存储过程 大虾们帮我看看哈
- 请教如何正确执行带有返回参数的存储过程
- oracle 發mail亂碼問題
- 求一个行列转换的SQL语句
- 位操作
- 我装了Oracle 9i 一启动就内存就使用800多M!!!天...
- 如何去年???????50分
- ****设置一个批次允许最大执行的时间****
- Oracle还原dmp文件时报错IMP-00003: 遇到 ORACLE 错误 1658和ORA-01658:无法为表空间XXX中的段创建INITIAL区
- 同时更新两条不同字段
- select into 返回的是多行值,想要保存并显示出来必须用游标吗
on 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