Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
|
hi, SELECT Sum(acpt_qty),mat_code1 FROM view_mrir_esd GROUP BY mat_code1 SELECT Sum(net_qty),mat_code1 FROM view_bom_total GROUP BY mat_code1 these 2 queries are giving the actual report, but when combining these queries like SELECT DISTINCT view_bom_total.mat_code1,Sum(net_qty),Sum(view_mrir_esd.acpt_qty) FROM view_bom_total inner join view_mrir_esd ON view_bom_total.mat_id=view_mrir_esd.mat_id GROUP BY view_bom_total.mat_code1 giving the wrong acpt_qty and net_qty. Please advise … 
|