Though this seems like a stupid question why not just use a left outer join?
Of course I didn't see any code as I must have deleted the original so this
may all be moot.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

  _____  

From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:29 PM
To: CF-Talk
Subject: Sub Query of a QofQ


Hi

Is it possible to have a simple query have a sub query using QofQ.  It
sounds like it could work but how do you determine the datasource?

What I am getting at is

<cfquery datasource="mydsn">

Select thedate from datetable where thedate in (select * from the
QofQResult)

</cfquery>

How would you get the above to work?

Thanks

Mike
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to