Combining 2 SQL queries and getting result set in one

You can aliasing both query and Selecting them in the select query SELECT x.a, y.b FROM (SELECT * from a) as x, (SELECT * FROM b) as y