Re: SQL Exception join

-----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-----