JOIN 3 QUERIES as a single table/view

user_14091472 0
Viewed 31

How can I JOIN these 3 queries in to a single view

SELECT A,B,C FROM TABLE1

SELECT D,E,F FROM TABLE 2 WHERE G = 'TOM'

SELECT H,I,J FROM TABLE 2 WHERE G = 'HARRY'


OUTPUT TABLE/VIEW:

A,B,C,D,E,F,H,I,J
google-cloud-platform sql
2 Answers

You can use cross join:

SELECT *
FROM (SELECT A,B,C FROM TABLE1) t1 CROSS JOIN
     (SELECT D,E,F FROM TABLE 2 WHERE G = 'TOM') tom CROSS JOIN
     (SELECT H,I,J FROM TABLE 2 WHERE G = 'HARRY') harry
user_11440350

This is what worked for me.

SELECT A,B,C from T1
LEFT JOIN
(SELECT D,E,F FROM T2 WHERE G ='TOM') ON T1.A = T2.D
LEFT JOIN
(SELECT H,I,J FROM T2 WHERE G = 'HARRY') as T3 ON T1.A = T3.H
user_140914720
Related