"Vayse" <vvv> wrote in message news:uj6qm1kOHHA.324@TK2MSFTNGP06.phx.gbl...
> Hi
> I have a select statement, which works fine.
> SELECT dbo.ZZZ_MONTHLY_Pre.ISNewBusiness
> FROM dbo.ZZZ_MONTHLY_Pre
> INNER JOIN
> dbo.AAA_MONTHLY_Clients ON
> dbo.ZZZ_MONTHLY_Pre.Ref = dbo.AAA_MONTHLY_Clients.Ref
>
> Now I wish to an update,
> UPDATE dbo.ZZZ_MONTHLY_Pre
> INNER JOIN
> dbo.AAA_MONTHLY_Clients ON
> dbo.ZZZ_MONTHLY_Pre.Ref = dbo.AAA_MONTHLY_Clients.Ref
> SET dbo.ZZZ_MONTHLY_Pre.IsNewBusiness = 1
>
> but I get: Incorrect syntax near the keyword 'INNER'.
>
> What should I be doing differently?
> thanks
> Vayse
>
>
>

"AlterEgo" <alterego55@dslextreme.com> wrote in message
news:eoKhfmmOHHA.320@TK2MSFTNGP06.phx.gbl...
> Vayse,
>
> I think this should work:
>
> update dbo.ZZZ_Monthly_Pre
> set IsNewBusiness = 1
> from
> dbo.ZZZ_Monthly_Pre
> inner join dbo.AAA_Monthly_Clients on ZZZ_Monthly_Pre.Ref =
> AAA_MonthlyClients.Ref
>
> -- Bill
>
> "Vayse" <vvv> wrote in message
> news:uj6qm1kOHHA.324@TK2MSFTNGP06.phx.gbl...
>> Hi
>> I have a select statement, which works fine.
>> SELECT dbo.ZZZ_MONTHLY_Pre.ISNewBusiness
>> FROM dbo.ZZZ_MONTHLY_Pre
>> INNER JOIN
>> dbo.AAA_MONTHLY_Clients ON
>> dbo.ZZZ_MONTHLY_Pre.Ref = dbo.AAA_MONTHLY_Clients.Ref
>>
>> Now I wish to an update,
>> UPDATE dbo.ZZZ_MONTHLY_Pre
>> INNER JOIN
>> dbo.AAA_MONTHLY_Clients ON
>> dbo.ZZZ_MONTHLY_Pre.Ref = dbo.AAA_MONTHLY_Clients.Ref
>> SET dbo.ZZZ_MONTHLY_Pre.IsNewBusiness = 1
>>
>> but I get: Incorrect syntax near the keyword 'INNER'.
>>
>> What should I be doing differently?
>> thanks
>> Vayse
>>
>>
>>
>
>