Toad World® Forums

SUBQUERY

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

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.

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.

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

Seems like a fine idea

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]
Sent: Friday, April 22, 2016 7:13 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] SUBQUERY

RE: SUBQUERY

Reply by Debbie Peabody

Seems like a fine idea

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum

Flag this post as spam/abuse.

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

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]
Sent: Friday, May 13, 2016 7:53 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] SUBQUERY

RE: SUBQUERY

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 on this subject.
Or Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum

Flag this post as spam/abuse.