SELECT DISTINCT q1.whatever
FROM q1, q2
WHERE q1.id = q2.id
AND q2.blah = 'blah'

Will do the same thing I think

Pascal

> -----Original Message-----
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: 27 July 2004 21:08
> To: CF-Talk
> Subject: Nested Query of Queries
>
> Is it possible to do a nested QoQ query?  For example
>
>
>
> Select * from somequery where id IN (select id from someotherquery
where
> blah='blah')
>
>
>
> It doesn't look like QoQ supports this. is there a workaround?
>
>
>
> Russ
>
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to