04 Jul 2016 11:07
05 Jul 2016 13:11
SELECT r.codigo
,r.cod,
,r.descr
,r.qtde
,q.qtsai
FROM a19req r
INNER JOIN (SELECT t.req_cod
,SUM(t.qtde) as qtsai
FROM a19item t
WHERE t.req_cod = r.codigo
GROUP BY t.req_cod ) as q
ON r.codigo = q.req_cod
LEFT JOIN titemg i
ON r.cod = i.codigo
WHERE r.status = 'A'
AND (r.qtde - q.qtsai) > 0
05 Jul 2016 14:21
07 Jul 2016 08:10