Re: SQL: how to join header and detail records

[rob@xxxxxxxxx]

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