Re: SQL: how to join header and detail records

OMG. I thought the comment was only a comment for the rest of the line,
like it is for imbedded SQL in RPG.
Thanks for slapping that into me. I needed it.

this is fully functional
Select orderno, totqty, sum(ifnull(dtlqty,0)) as dtlsum
from orderheader left outer join orderdetail using (orderno)
group by orderno, totqty
having totqty <> sum(ifnull(dtlqty,0))
order by orderno, totqty

ORDERNO TOTQTY DTLSUM
2 12 10
3 12 0

select * from qtemp/orderheader
ORDERNO TOTQTY
1 10
2 12
3 12

select * from qtemp/orderdetail
ORDERNO DTLQTY
1 5
1 5
2 5
2 5




Rob Berendt