I need to make three select queries over three different tables, using the outputs of each select query, the catch is each one gives multiple results. Here is how I do it.
Select "Title", "Num" from "Table" where "Id" in ( Select "Id" from "Table2" where "Id" in ( select distinct "Id" from "Table3" where foo-clause ) )
İt only gives me the result of one of the results. How can I make each one use multiple inputs?