I am trying to join two tables based on the condition.
How can I join ID from table 1 with DepartmentID and LaboratoryID with table 2?
I tried below and didn't work
INNER JOIN Table1 ON
(SELECT ID FROM Table1 WHERE Portfolio = 'Department') =
(SELECT ID FROM Table1 WHERE Portfolio = 'Laboratory') =
- This topic was modified 3 weeks, 5 days ago by learner0.