Updating query using inner join sintax error
I have an error of sintax on this code
UPDATE a
SET [FWCreation] = b.[FiscalWeek]
, [FWConversion] = b.[FiscalWeek]
FROM QuotesFile a
INNER JOIN tblFiscalDate b ON
( a.[Creation Date] BETWEEN b.[WeekBegin] AND b.[WeekEnd] ) AND
( a.[Conversion Date] BETWEEN b.[WeekBegin] AND b.[WeekEnd] )
|