Re: SQL Exception join

[GUY_HENZA@xxxxxxxxxxxxxx]

Select * from table1 where keyfld not in (select keyfld from table2)
???

Regards,

Guy



                                                                                                                                          
                      "Tim Gornall"                                                                                                       
                      <tgornall@xxxxxxxxxx        To:       <midrange-l@xxxxxxxxxxxx>                                                     
                      >                           cc:                                                                                     
                      Sent by:                    Subject:  SQL Exception join                                                            
                      midrange-l-bounces@m                                                                                                
                      idrange.com                                                                                                         
                                                                                                                                          
                                                                                                                                          
                      12/12/2007 03:09 PM                                                                                                 
                      Please respond to                                                                                                   
                      Midrange Systems                                                                                                    
                      Technical Discussion                                                                                                
                                                                                                                                          
                                                                                                                                          





I the exception join unique to DB2 UDB?  If so, how would you do the
following simple query on other platforms?  Just curious.

Select all in table 1 without a match in table 2

Thanks, Tim


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.