Re: SQL: how to join header and detail records

Correct. This a real working example

Select orderno, max(totqty), sum(dtlqty) as dtlsum
from orderheader join orderdetail using (orderno)
group by orderno
having max(totqty) <> sum(dtlqty)
ORDERNO MAX ( TOTQTY ) DTLSUM
2 12 10

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

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


Rob Berendt