RE: Finding orphans using SQL

Select * from OrderHeader a where not exists (select * from OrderDetail
b where a.CustomerNbr = b.CustomerNbr and a.OrderNbr = b.OrderNbr)

hth
Dave

>----------
>From:  Don Schenck[SMTP:don.schenck@kwsoft.com]
>Sent:  Thursday, May 01, 1997 10:38 AM
>To:    'midrange-l@midrange.com'
>Subject:       Finding orphans using SQL
>
>All --
>
>Is there a method in SQL that can be used to find "childless" header 
>records? And this would include situations where the table has a 
>multi-column index as it's primary index.
>
>Example:
>
>OrderHeader
>-----------
>Key Fields: CustomerNbr, OrderNbr
>
>
>
>OrderDetail
>-----------
>Key Fields: CustomerNbr, OrderNbr, LineNbr
>
>
>
>I want to find ALL the OrderHeader records that do NOT have any
>OrderDetail 
>records. I'm drawing a blank right now.
>
>
>
>
>Peace,
>
>-- Don Schenck
>
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>*
>* This is the Midrange System Mailing List!  To submit a new message,  
>*
>* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from    
>*
>* this list send email to MAJORDOMO@midrange.com and specify           
>*
>* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions     
>*
>* should be directed to the list owner / operator: david@midrange.com  
>*
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>*
>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *