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