[Solved] SELECT a subset of records from Table A that match two columns in table B

by

[ad_1]

Put an “AND” in your join clause instead of joining twice.

SELECT Users.*
FROM Users
INNER JOIN ActiveJobs DEP
ON Users.Department = DEP.Department AND Users.JobTitle = DEP.JobTitle

0

[ad_2]

solved SELECT a subset of records from Table A that match two columns in table B