Help with a more complex query

jim.mccann_718 · February 7, 2011, 10:39am

Need a receomendation for how to implement this in TOAD

I have a query in query builder that uses about 10 tables. One of the variables needs to populate from case statement and a sub query for example

CASE WHEN varx IS NOT NULL THEN 1 WHEN varx IS NULL AND vary IN (SELECT varz FROM t2) THEN 2 ELSE 1000 END

Also is there an advanced query builder tutorital that I can reference?

Jim

Debbie_Peabody · February 7, 2011, 12:19pm

See the bottom of this post and see if that helps.

Debbie