What database platform and what version of cf? -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 5:55 PM To: CF-Talk Subject: OT: Can't use UNION
I am putting together an application and I canot use UNION, here is my query that I have used in the past, does anyone have a solution that would not use UNION? SELECT state, state_abv FROM #request.taxStateTable# UNION ALL SELECT province AS state, province_abv AS state_abv FROM #request.taxCanadaTable# ORDER BY 1 Thank you Paul Giesenhagen QuillDesign ______________________________________________________________________ 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
