Help with a more complex query

Toad Data Point
1

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

2

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

http://tda.inside.quest.com/thread.jspa?threadID=28972

Debbie