I’m trying to create a map to show different types of locations in there, I have four queries in MySQL and I need to do the inner join between two of this four queries but if I do a JOIN tranformation it always try to join all my queries and delete the two that doesn’t have that field but I want to do this only in two. There is a way to doing that?
are these tables located on same server and same database?
No, the tables are located on the same MySQL server, but in different databases, so I can’t do the JOIN directly on the query
SELECT a.var1, a.var2, a.var3, ...
FROM database1.table1 a
JOIN database2.table2 b