[thelist] SQL help

[Tim Burgan]

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