Can you tell me please the right syntax to join subqueries?
SELECT Col1, Col2 a
WHERE Condition1 and Condition2
outer left join
SELECT Col1, Col2 b
But it does not seem to work.
Please not I want to first generate the tables I want with the appropriate filters and AFTERWARDS join the tables. I do not want the opposite as it is not efficient. If there is another syntax for the opposite, please let me know for future use