Hot answers tagged

2

You are also able to use the INTERSECT keyword. SELECT name FROM people JOIN *tablesyouwanttojoin* WHERE name = "actor number 1" INTERSECT SELECT name FROM people JOIN *tablesyouwanttojoin* WHERE name = "actor number 2" This was the most elegant suggestion I could find online since I had the same problem...


Only top voted, non community-wiki answers of a minimum length are eligible