>- see footer for list info -< Go on Snakie, thank him, you know you want to! :OD
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robertson-Ravo, Neil (RX) Sent: 18 January 2006 15:25 To: Coldfusion Development Subject: RE: [CF-Dev] UNION >- see footer for list info -< Yes you can, with either UNION or UNION ALL depending on your need. Databases and Database names have to be fully qualified however which can lead to some 'orrible sql sets. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 18 January 2006 15:24 To: 'Coldfusion Development' Subject: [CF-Dev] UNION >- see footer for list info -< Just wanted to confirm this before I go ahead and try doing it. I can use the UNION statement in SQL to select data from multiple databases and join then in a single result set right? Russ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
