I don't think so. You should get an error indicating that the fields id and username are ambiguous. If a record has the same id and username in both tables, things would be a little simplified, otherwise, you can do something like; SELECT 1 FROM tblStaff AS a , tblStudents AS b WHERE a.username = '$username' OR b.username = '$username' which would give you an EOF or a 1 Cheers Ken : -----Original Message----- : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Tim Burgan : Sent: Friday, 21 January 2005 6:11 PM : To: [thelist] thelist at lists.evolt.org : Subject: [thelist] SQL help : : hello : : is this the correct SQL to seach if a username already exist across two : tables, both containing id (unique number) and username (unique string) : fields? : : : SELECT id : FROM tblStaff, tbl Students : WHERE username = '$username'; : : : if the username does NOT exist the recordset will return EOF (End of : File). Is this correct? : : tim : : : : : -- : : * * Please support the community that supports you. * * : http://evolt.org/help_support_evolt/ : : For unsubscribe and other options, including the Tip Harvester : and archives of thelist go to: http://lists.evolt.org : Workers of the Web, evolt !