join multiple query results into 1 query
Posted on 2014-02-05
hey guys, i have 3 complex queries and they each give me just 1 value
so for example
Query 1: Output result --> 137
Query 2: Output result --> 33
Query 3: Output result --> 104
there is only 1 cell for each of the output results
Question: how do i join these into 1 resultant queries with 3 cells in 1 row?
i was thinking of using a union query but i don't think that will work as i am trying to add columns instead of rows
i was thinking about outer join but i don't have a unique key
the only way i can think of so far is to write it to a temporary table and then do a select query from there.
thanks in advance guys!