Yes, but you may need to alias the table name on the external query to avoid conflicts.
SELECT field1 FROM table AS exttable WHERE id IN (SELECT id FROM table WHERE field2 = exttable.field1) I know the example could be written without the subquery, but is just an example of the aliasing needed in this type of setup. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ----- Original Message ----- From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 10:10 AM Subject: Subquery from the same table: Is it possible?? > Is it possible to have a subquery from the same table to output data based > on a certain condition? > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
