Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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