# left outer join in query builder **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [April 1, 2011, 1:34pm UTC](https://forums.toadworld.com/t/left-outer-join-in-query-builder/6532 "2011-04-01T13:34:45Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![TDACSuser](https://avatars.discourse-cdn.com/v4/letter/t/87869e/32.png) [@TDACSuser](https://forums.toadworld.com/u/TDACSuser)\ **Post date:** [April 1, 2011, 1:34pm UTC](https://forums.toadworld.com/t/left-outer-join-in-query-builder/6532/1 "2011-04-01T13:34:45Z")
I have been trying to join two tables (one is a subquery). Table A has a complete list of part numbers “to buy”. Table B (subquery) has a partial ist of part numbers that have been “bought”. I only want to return a list of parts that have not been bought; so the difference between the two tables. This seems like a real simple left outer join. I’m using the query builder and asking it to select all part numbers from Table A where the part number in Table B is null. Instead, I’m getting my complete list of Table A. When I view the SQL code for the query builder, it doesn’t program the query with a “left outer join”. When I type it in manually into SQL, I get the data result I want. But I do most of my queries in the query builder and would like to know if I’m doing something wrong. ---
**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:** [April 3, 2011, 11:04pm UTC](https://forums.toadworld.com/t/left-outer-join-in-query-builder/6532/2 "2011-04-03T23:04:01Z")
I the posting below you can see how to set inner and outer joins in the Query Builder. [http://tda.inside.quest.com/thread.jspa?messageID=102554](http://tda.inside.quest.com/thread.jspa?messageID=102554) Debbie