Match The Usernames From 2 Tables

[An7hony]

Hi Guys

 

I am trying to match the usernames from 2 tables but then only show the usernames that are not matched

 

(the rows: users and candidate_name both hold usernames)

 

$query1 = "SELECT users FROM users";
$query2 = "SELECT candidate_name FROM applied_jobs";

 

Can anyone teach me how to do this?

 

Thanks guys

[An7hony]

Think this has worked

 

$q = "SELECT username
FROM   users
WHERE  NOT EXISTS (SELECT candidate_name
			   FROM   applied_jobs
			   WHERE  candidate_name = username)";

[spfoonnewb]

Here is another typical solution for this:

 

SELECT users.username FROM users LEFT JOIN applied_jobs ON users.username = applied_jobs.candidate_name WHERE applied_jobs.candidate_name IS NULL