Hello
I was wondering if it is possible to do a full outer join in cross connection query mode?
Cross connection query joins
While you can not directly use full outer join syntax, you can do a union of left and right joins to work around this.
ex.
select * from A RIGHT JOIN B ON A.COL = B.COL
UNION
select * from A LEFT JOIN B ON A.COL = B.COL
I just tried out the workaround and it worked great. thanks for the help