This is Access DB. Mark
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 10:17 AM To: CF-Talk Subject: RE: SQL Union Statement is this in Access or SQL Server? -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: 07 January 2003 15:18 To: CF-Talk Subject: SQL Union Statement Hi All, Am I using the UNION statement correctly to join two different queries based on two different tables in the same database? I can't seem to get the data from the pl_companies table to return a record. Thanks. ============================== <cfquery name="qSponsor1" datasource=#REQUEST.dsn1#> SELECT co_name, sponsor FROM tCultivarCompanies WHERE sponsor = 1 UNION SELECT co_name, sponsor FROM pl_companies WHERE sponsor = 1 ORDER BY co_name </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
