select t2.* from TableTwo t2 left join TableOne t1 on (t2.ID = t1.ID)
where t1.ID is NULL
- Original Message -
From: "Phillip S. Baker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 7:26 AM
Subject: Comparing Table IDs
> Gree
Greetings all,
I have 3-4 tables of members on a website.
However over time I have table one that lists 14000 records and table two
lists 14121 records.
What kind of SQL call would I put out to compare the two tables and find
out which records in table two do not have a corresponding ID number i