You need to change the awd_awardID (FK) from text to a number datatype with a specific type of long integer
Then it should work -----Original Message----- From: Debi Lewis [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2008 8:13 PM To: CF-Newbie Subject: Desperate help with LEFT OUTER JOIN I am banging my head on a wall trying to figure out what seems to be a simple issue. I am using Access at the client's request. I have all general info about awards in one table, and info about award winners in the other. The award winners table has a field called awd_awardID (a text field) that refers to the primary key (awd_ID) of the general award info table (an autonumber field). I've written a query to try to pull the name of the award from the general table and display it along with information about the winners. It's not working! <cfquery name="findlibwinners" datasource="awards"> SELECT w.awd_awardID, g.awd_ID, g.awd_name FROM ala_awards_libwinners w LEFT OUTER JOIN ala_awards_genawardsinfo g ON 'w.awd_awardID' = g.awd_ID WHERE 0=0 </cfquery> When I run it, I get this: Error Executing Database Query. Join expression not supported. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3754 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
