nested queries

nested queries

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'sean' on February 20, 2001 at 07:24:58 EST:

I need to run a 'nested ' query but can't get the syntax right. the query looks something like this:-

select (criteria) from
[select (criteria) from (tables) where (conditions)] where (conditions)
In other word a select query based on the results of another select query

Follow Ups:

Re: nested queries Wayneth 13:34:42 2/23/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : I need to run a 'nested ' query but can't get the syntax right. the query looks something like this:- : select (criteria) from : [select (criteria) from (tables) where (conditions)] where (conditions) : In other word a select query based on the results of another select query