Select productName from productQuery pq where EXISTS (select batchID from
productQuery where pq.batchID<>productQuery.batchID and
productName=pq.productName)
I haven't tested this query to make sure it works, but basically I'm
selecting from a table (query) and I want all the items which exist with
more then 1 batchID.
Is this possible to do with QoQ, or do I need to do some weird workaround,
or use a db?
Russ
_____
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 3:17 PM
To: CF-Talk
Subject: RE: Nested Query of Queries
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]
