Andrew Select Postcode from Table 1 where PostCode not in ( select Postcode from Table2)
HTH Terry McDonnell -----Original Message----- From: Andrew Tracey [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 15:01 To: Terry McDonnell Subject: MI-L SQL Querying Dear All Does anyone know of a way of querying for all non-matched entries between 2 different tables? I have two tables with postcode in and want to find which don't match. Thanks Andrew Tracey --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18188