LEFT OUTER or LEFT INNER
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Greavesy
Sent: Tuesday, 23 October 2007 12:56 PM
To: cfaussie
Subject: [cfaussie] LEFT JOIN in update cfquery
Could someone please shed some light on a cfquery that I am working on. I
am receiving a syntax error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the
keyword 'LEFT'.
<cfquery datasource="#application.Dsn_dev0eucActuary#">
UPDATE TagtT_EFFDATEFINYRS LEFT JOIN
TagtVS_EFFDATEupd ON
TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno SET
TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol],
TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] </cfquery>
Any guidance/help would be appreciated.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
