# LEFT JOIN

**URL:** <https://forums.toadworld.com/t/left-join/6040>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [September 15, 2009, 8:31am UTC](https://forums.toadworld.com/t/left-join/6040 "2009-09-15T08:31:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![martin.vyhnanek\_484](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@martin.vyhnanek\_484](https://forums.toadworld.com/u/martin.vyhnanek_484)\
**Post date:** [September 15, 2009, 8:31am UTC](https://forums.toadworld.com/t/left-join/6040/1 "2009-09-15T08:31:02Z")

</div>

Hallo, could I use command LEFT JOIN and RIGHT JOIN, please?

Thank you,

Martin

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [September 15, 2009, 11:15am UTC](https://forums.toadworld.com/t/left-join/6040/2 "2009-09-15T11:15:53Z")

</div>

To add an LEFT or Right outer join, right click on the join line and choose the table you want to select all rows from. See attachment.

Debbie

 ![OuterJoins.png](https://global.discourse-cdn.com/quest/original/2X/e/eeb27467d22845a52d07e96178f218ecaa163449.png)