Cross connection query joins

Toad Data Point & Toad Intelligence Central
1

Hello

I was wondering if it is possible to do a full outer join in cross connection query mode?

2

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

3

I just tried out the workaround and it worked great. thanks for the help