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 > 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 in > table one. > Make sense?? > > Thanks > > Phillip > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
