摘要：
select a.*,b.*from(select t1.line_id,abs(sum(t1.quantity)) db_so,abs(t2.ordered_quantity) od_so from SECOM_SOPO_MATCHES t1,ont.oe_order_lines_all t2where t1.line_id=t2.line_id --and t1.line_id=466338group by t1.line_id,t2.ordered_quantityhaving abs(sum(t1.quantity))<>abs(t2.ordered_quantity) ) 阅读全文
posted @ 2012-05-29 16:36 奥客 阅读(169) 评论(0) 推荐(0) 编辑