# Cross connection query joins

**URL:** <https://forums.toadworld.com/t/cross-connection-query-joins/28897>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 20, 2014, 10:07pm UTC](https://forums.toadworld.com/t/cross-connection-query-joins/28897 "2014-02-20T22:07:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ginty2](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ginty2/32/241_2.png) [@ginty2](https://forums.toadworld.com/u/ginty2)\
**Post date:** [February 20, 2014, 10:07pm UTC](https://forums.toadworld.com/t/cross-connection-query-joins/28897/1 "2014-02-20T22:07:44Z")

</div>

Hello

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

---

<div class="post-metadata">

**Author:** ![RyanJohnson](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@RyanJohnson](https://forums.toadworld.com/u/RyanJohnson)\
**Post date:** [February 21, 2014, 10:54am UTC](https://forums.toadworld.com/t/cross-connection-query-joins/28897/2 "2014-02-21T10:54:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ginty2](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ginty2/32/241_2.png) [@ginty2](https://forums.toadworld.com/u/ginty2)\
**Post date:** [February 21, 2014, 11:08am UTC](https://forums.toadworld.com/t/cross-connection-query-joins/28897/3 "2014-02-21T11:08:49Z")

</div>

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