|
Subject:
|
Updating query using inner join sintax error
|
|
Posted By:
|
gfranco
|
Post Date:
|
4/18/2008 10:08:18 PM
|
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] )
|
|
