Advertisement
Guest User

Untitled

a guest
Jul 19th, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT I.T076IDTRANSF CARGA, SUM(I.T076QTD) QTD FROM T076ITTRANSF I WHERE I.T076IDTRANSF = :?1 AND  I.T076QTD > 0 GROUP BY 1 UNION ALL SELECT ID.T093IDDEV CARGA, SUM(ID.T093QUANT) QTD FROM T093ITDEV ID WHERE ID.T093IDDEV = :?1 AND ID.T093QUANT > 0 GROUP BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement