Toad World® Forums

Cross connection query joins


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.


select * from A RIGHT JOIN B ON A.COL = B.COL


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