Re: SQL Exception join

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Pete

The OP is looking for the syntax in other SQL dialects, such as 
Oracle or SQL Server - says they do not have the exception join available.

Vern

At 08:29 PM 12/12/2007, you wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I must have missed something.
>
> Why not
>   select * from table1 a
>   exception join table2 b
>     on a.keyfld = b.keyfld
>
> Will return all the rows from table1 that don't have a matching row in
> table2.
>
> Pete Hall
> pbhall@xxxxxxxxxxxxx
>
>
> GUY_HENZA@xxxxxxxxxxxxxx wrote:
> > 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.
> >
> >
> >
> >
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFHYJkQpcZsDl8OX6kRAgfJAJ475nfhfn+hbXfinGF/lesBkuanJACeIt1U
> IeVPSvK2fektvtr7AE+UZQs=
> =zGjo
> -----END PGP SIGNATURE-----
> --
> 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.