Use Q of Q. It provides support for UNIONS. HTH,
Sam ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 8:50 PM Subject: Re: Can't use UNION > It is a distributed app .. > > Paul Giesenhagen > QuillDesign > > ----- Original Message ----- > From: "Ken Wilson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, September 24, 2002 7:50 PM > Subject: RE: Can't use UNION > > > > >I need a query that works in both MySQL and MS SQL 2000 > > > > > > > > Why? > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
