Need the order by in there ... UNION is not supported in MySQL and I need a query that works in both MySQL and MS SQL 2000
Thank you Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Thanh Nguyen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 5:02 PM Subject: RE: Can't use UNION > remove "order by". > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 24, 2002 2: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
