I have two queries to get data from each table on their respective server. When I try to do a "query of queries", I only get data for records with data in both tables. I need to basically do a left join, but the information I have found so far says this isn't possible in query of queries in ColdFusion.
My query for getting just records with data in both tables is: <CFQUERY NAME="rsJoined" DBTYPE="QUERY"> SELECT * FROM rsEmployees, rsPhones WHERE rsEmployees.Employee = rsPhones.EmployeeNo </CFQUERY> My query that gets a listing of all records, but shows the same data (the information for the record with data in both tables) for every record is: <CFQUERY NAME="rsJoined" DBTYPE="QUERY"> SELECT rsEmployees.EMPLOYEE, rsEmployees.LAST_NAME, rsEmployees.FIRST_NAME, rsEmployees.MIDDLE_INIT, rsEmployees.DESCRIPTION, rsEmployees.EXPR1, rsEmployees.PROCESS_LEVEL, rsPhones.EmpPhoneID, rsPhones.EmployeeNo, rsPhones.PhoneNo FROM rsEmployees, rsPhones WHERE rsEmployees.Employee = rsPhones.EmployeeNo </CFQUERY> Can anyone help? Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:15:515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
