Why do you want to combin then ? -----Original Message----- From: Gene Kraybill [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 19:21 To: CF-Talk Subject: OT: combining SQL queries <CFQUERY NAME="GetSenderDetails" DATASOURCE="#datasource#"> SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#Session.UserNumber# </CFQUERY> <CFQUERY NAME="GetOrdererDetails" DATASOURCE="#datasource#"> SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.UserNumber# </CFQUERY> <CFQUERY NAME="GetApproverDetails" DATASOURCE="#datasource#"> SELECT UserName, FirstName, LastName, Email FROM Users WHERE UserNumber=#GetOrder.ApprovalBy# </CFQUERY> Any way to combine these three queries and still be able to reference the Sender, Orderer and Approver in my output? Gene Kraybill --------------------------------- Gene Kraybill LPW & Associates LLC www.lpw.net ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.