Question

SQL执行出错，标识符无效

select b.Attribute5 原合同号,
b.httc 统筹,
b.HTTCRDM 合同管理员
sh.ORDER_SHIP_DATE 实际发货日期,
from appl.order_lines_all a,
appl.order_headers_all b,
appl.mtl_system_items c,
APPL.RA_SITE_ADDRS_ALL RSAA,
appl.products p
where a.wo_number = b.wo_number
and c.inventory_item_id = a.inventory_item_id
and b.ship_to_site_use_id=rsaa.site_use_id(+)
and b.product_code=p.product_code
and to_char(SH.ORDER_SHIP_DATE,'yyyy-mm-dd') --实际发货时间
between '2015-03-07' and '2015-03-08'
and c.organization_id = a.WAREHOUSE_ID
group by b.ATTRIBUTE5,
b.httc,
b.HTTCRDM

Answer 1

 select b.Attribute5 原合同号,
       b.httc 统筹,
       b.HTTCRDM 合同管理员    //缺少逗号
       sh.ORDER_SHIP_DATE 实际发货日期,    //sh哪里来的？
  from appl.order_lines_all   a,
       appl.order_headers_all b,
       appl.mtl_system_items  c,
       APPL.RA_SITE_ADDRS_ALL RSAA,
       appl.products p

Answer 2

仔细检查一下是不是某个字段写错了