Using the result set of a select query as the input of another select

3 votes

1 answer

10086 views

                          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?

Asked by EvsizTospaa (33 rep)

Apr 5, 2018, 02:04 PM
Last activity: Apr 5, 2018, 04:21 PM

Using the result set of a select query as the input of another select

Related Questions