Re: nested queries

Re: nested queries

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

Posted by 'Wayneth' on February 23, 2001 at 13:34:42 EST:

In Reply to: nested queries 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

I think your subquery needs to be in parentheses.

Follow Ups:

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 : : I think your subquery needs to be in parentheses.