# SUBQUERY

**URL:** <https://forums.toadworld.com/t/subquery/6354>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [October 12, 2010, 10:13pm UTC](https://forums.toadworld.com/t/subquery/6354 "2010-10-12T22:13:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jim.mccann\_718](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@jim.mccann\_718](https://forums.toadworld.com/u/jim.mccann_718)\
**Post date:** [October 12, 2010, 10:13pm UTC](https://forums.toadworld.com/t/subquery/6354/1 "2010-10-12T22:13:21Z")

</div>

Where can I find documentation on creating a SUBQUERY within the QUERY builder?

---

<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:** [October 13, 2010, 12:46pm UTC](https://forums.toadworld.com/t/subquery/6354/2 "2010-10-13T12:46:40Z")

</div>

There is a short help topic if you use the index and search the keyword subquery.

Basically, subqueries that are in the where condition are created starting from the where condition editor. There is a button that will create a new Query builder environment with a navigational panel. See screeshots.

If you want to create a subquery as a column you will need to use the calculated column editor.

 ![Subquery2.png](https://global.discourse-cdn.com/quest/original/2X/6/61143de93e138cf6f58fd8bc166ca5be9cd5afde.png)

---

<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:** [October 13, 2010, 12:46pm UTC](https://forums.toadworld.com/t/subquery/6354/3 "2010-10-13T12:46:40Z")

</div>

There is a short help topic if you use the index and search the keyword subquery.

Basically, subqueries that are in the where condition are created starting from the where condition editor. There is a button that will create a new Query builder environment with a navigational panel. See screeshots.

If you want to create a subquery as a column you will need to use the calculated column editor.

 ![Subquery1.png](https://global.discourse-cdn.com/quest/original/2X/9/9fb0cf41d266c6e5115c3e33d4f9df96a6f729cc.png)

---

<div class="post-metadata">

**Author:** ![Sylatupa](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sylatupa](https://forums.toadworld.com/u/Sylatupa)\
**Post date:** [April 19, 2016, 12:58pm UTC](https://forums.toadworld.com/t/subquery/6354/4 "2016-04-19T12:58:31Z")

</div>

I think a video on adding subqueries using the Graphical Builder would be helpful. Would you be willing to do that @Debbie Peabody? 🙂

---

<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:** [April 22, 2016, 7:11pm UTC](https://forums.toadworld.com/t/subquery/6354/5 "2016-04-22T19:11:29Z")

</div>

Seems like a fine idea

---

<div class="post-metadata">

**Author:** ![Sylatupa](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sylatupa](https://forums.toadworld.com/u/Sylatupa)\
**Post date:** [May 12, 2016, 10:23am UTC](https://forums.toadworld.com/t/subquery/6354/6 "2016-05-12T10:23:34Z")

</div>

It would be increadibly helpful for the Arizona State University Employees to have the subquery video.

As you may know, we’ve committed to using Toad and Toad Intelligence Central as our tool for reporting.

I’m providing links to Toad world and those video resources for training.

When do you think you can make the video? I would GREATLY appreciate it.

Thank you,

Shaun Ylatupa-McWhorter

**From:** Debbie Peabody [[mailto:bounce-Debbie\_Peabody@toadworld.com](mailto:bounce-Debbie_Peabody@toadworld.com)]  
**Sent:** Friday, April 22, 2016 7:13 PM  
**To:** [toaddatapoint@toadworld.com](mailto:toaddatapoint@toadworld.com)  
**Subject:** RE: [Toad Data Point - Discussion Forum] SUBQUERY

**[RE: SUBQUERY](http://www.toadworld.com/products/toad-data-point/f/36/p/6425/60266#60266)**

Reply by Debbie Peabody

Seems like a fine idea

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/6425?subscribe=false) on this subject.  
Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36?subscribe=false) notifications altogether.  
Toad Data Point - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/6425/60266?AbuseContentId=73ebcd67-8358-49b2-890a-6a17a75b2de1&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

---

<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:** [May 13, 2016, 7:51pm UTC](https://forums.toadworld.com/t/subquery/6354/7 "2016-05-13T19:51:30Z")

</div>

I entered QAT-7892 to make the video. Give me a couple of weeks.

---

<div class="post-metadata">

**Author:** ![Sylatupa](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sylatupa](https://forums.toadworld.com/u/Sylatupa)\
**Post date:** [May 16, 2016, 1:40pm UTC](https://forums.toadworld.com/t/subquery/6354/8 "2016-05-16T13:40:21Z")

</div>

Great news Debbie, thank you.

I may get a list of frequently asked questions over to you and see if you, or your team, can build some of those videos too—instead of getting them to you piecemeal.

I’m compiling some documentation now for ASU, but I think the videos are much more helpful than text resources.

Talk to you soon.

**From:** Debbie Peabody [[mailto:bounce-Debbie\_Peabody@toadworld.com](mailto:bounce-Debbie_Peabody@toadworld.com)]  
**Sent:** Friday, May 13, 2016 7:53 PM  
**To:** [toaddatapoint@toadworld.com](mailto:toaddatapoint@toadworld.com)  
**Subject:** RE: [Toad Data Point - Discussion Forum] SUBQUERY

**[RE: SUBQUERY](http://www.toadworld.com/products/toad-data-point/f/36/p/6425/60658#60658)**

Reply by Debbie Peabody

I entered QAT-7892 to make the video. Give me a couple of weeks.

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/6425?subscribe=false) on this subject.  
Or [Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36?subscribe=false) notifications altogether.  
Toad Data Point - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/6425/60658?AbuseContentId=a5aee135-4770-46a3-9f82-f291e08af785&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.
