Guest User

Untitled

a guest
Oct 22nd, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. select a.item_code , a.rep_code ,sum(t.sales_target) , sum(a.actual)
  2. from sales_target t join sales_actual a
  3. on a.item_code = t.item_code and a.rep_code = t.rep_code
  4. group by a.item_code , a.rep_code
Add Comment
Please, Sign In to add comment