This query was orignially written for MS SQL 2000 and needs to work in both MS SQL 2000 and MySQL :) So I am looking for another way around putting two tables together to get results named the same.
Thanks! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Joshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 5:20 PM Subject: RE: Can't use UNION > 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 > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
