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

by


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

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