Full Outer Join in SQL

hamza_123

As of now we cannot do a full outer join in SQL, probably because MySQL does not support a Full Outer JOIN. However, this is a very important function. 

The work around this (LEFT JOIN union RIGHT JOIN) is very long, and in complex queries becomes very conoluted. 

 

Can Domo do something about this?  

 

( I know outer join exists in ETL)