Check two tables for email

[scotchegg78]

Hi Guys

 

Easy one, but maybe i am tired or full of cold, but my query is wrong??!

i am simply trying to check two tables to see if the email has already been registered.

But it returns nothing if one of the tables for example job seeker is empty, even though the required email is in the recruiter table already..

 

SELECT job_seeker.email,job_recruiter.email

FROM job_seeker,job_recruiter

WHERE (job_recruiter.email = 'test@email.com') OR (job_seeker.email = 'test@email.com');

 

thanks for any quick fix

 

[fenway]

That's because it's an inner join -- you want UNION.