UNION before INNER JOIN

inner-join, sql, union

Solution

You are getting an error because that is not valid SQL Syntax. `UNION ALL` syntax is:

SELECT <column1>
FROM <table1>
UNION ALL
SELECT <column1>
FROM <table2>

You cannot reference the columns from either query like you are trying to do. If you want to reference, then you will want to use something like this:

select *
from 
(
    select some_table1.some_column1, some_table1.some_column2
    FROM some_table1
    UNION ALL
    select some_table2.some_column1, some_table2.some_column2
    FROM some_table2
) t1
INNER JOIN some_table3
ON  some_table3.some_column1 = t1.some_column1

Problem

Why when I use UNION before INNER JOIN like this ``` select some_table1.some_column1, some_table1.some_column2 FROM some_table1 UNION ALL select some_table2.some_column1, some_table2.some_column2 FROM some_table2 INNER JOIN some_table3 ON some_table3.some_column1 = some_table1.some_column1 ``` I have an eror: could not bound multi-part identifer "some_table3.some_column1"? All data types are compatible.

Original source