[Solved] SELECT a subset of records from Table A that match two columns in table B
[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