Toad World® Forums

Cross connection query joins

Hello

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

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