Erm... am I missing something here? Aren't these 2 queries pulling the same (or a subset of the same) data from the same table? What does the second query get you that the first query doesn't?
-- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Bosky, Dave [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 2:39 PM > To: CF-Talk > Subject: cfquery - subquerie> > > > How would I go about combining these 2 queries into a single query? > Or would it be best to leave it seperated into 2. > > Thx, Dave > > <CFQUERY name="qEmployeeList" DATASOURCE="myDSN"> > SELECT employee_number,emp_last_name, emp_preferred_name, > sup_short_name, email_id > FROM tbl_Employee > WHERE employee_number = #FORM.EmployeeName# > </CFQUERY> > > <CFQUERY NAME="qSupervisorData" DATASOURCE="myDSN"> > SELECT email_id > FROM tbl_Employee > WHERE emp_short_name = '#Trim(qEmployeeList.sup_short_name)#' > </CFQUERY> > > > HTC Disclaimer: The information contained in this message may be > privileged and confidential and protected from disclosure. If the > reader of this message is not the intended recipient, or an > employee or agent responsible for delivering this message to the > intended recipient, you are hereby notified that any > dissemination, distribution or copying of this communication is > strictly prohibited. If you have received this communication in > error, please notify us immediately by replying to the message > and deleting it from your computer. Thank you. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
