Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select a.item_code , a.rep_code ,sum(t.sales_target) , sum(a.actual)
- from sales_target t join sales_actual a
- on a.item_code = t.item_code and a.rep_code = t.rep_code
- group by a.item_code , a.rep_code
Add Comment
Please, Sign In to add comment