Using a similar example but assuming that the DeptNo is divided into two columns, the following statement could be used:
SELECT Name FROM Employee WHERE (DeptNoA, DeptNoB) IN (SELECT DeptNoA, DeptNoB FROM Department WHERE Loc = 'LAX') ;
Using a similar example but assuming that the DeptNo is divided into two columns, the following statement could be used:
SELECT Name FROM Employee WHERE (DeptNoA, DeptNoB) IN (SELECT DeptNoA, DeptNoB FROM Department WHERE Loc = 'LAX') ;