How can I query 2 different tables using the same criteria. I want to have
one query that grabs all the information as below
<cfquery name="options" datasource="mydatasource" dbtype="ODBC">
Select DISTINCT state, city
From attractions, properties
Order by state
</cfquery>
Basically I only want unique city and states from the attractions and
properties database.
What is the best way to do this.
TIA!
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
