|Date: ||Wed, 22 Dec 1999 20:57:23 GMT|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|Organization: ||Deja.com - Before you buy.|
|Subject: ||Re: records compare|
Suppose you have a key (e.g. ID) in both tables, you can do this:
where id not in
If it returns "No Rows Selected", all the records(IDs to be exeact) in
tbl2 are in tbl1, otherwise the IDs that are in tbl2 but not in tbl1
will be listed.
In article <firstname.lastname@example.org>,
Kathy White <kathyzhi@HOTMAIL.COM> wrote:
> There are two tables, tbl1 and tbl2. how can I check if all records in
> tbl2 exist in tbl1? Thanks in advance for any suggestion.
> Get Your Private, Free Email at http://www.hotmail.com
Sent via Deja.com http://www.deja.com/
Before you buy.