Try UPDATE TagtT_EFFDATEFINYRS SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] FROM TagtVS_EFFDATEupd LEFT JOIN TagtT_EFFDATEFINYRS ON TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno
You might have to change the LEFT JOIN to a RIGHT JOIN now Pauline On Oct 23, 12:55 pm, Greavesy <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---