Hi I have added the highlighted following syntax but it errors near WHERE can anyone help ? FROM dbo.INVENTLOCATION INNER JOIN dbo.SALESTABLE ON dbo.INVENTLOCATION.INVENTLOCATIONID = dbo.SALESTABLE.INVENTLOCATIONID INNER JOIN dbo.SALESLINE ON dbo.SALESTABLE.SALESID = dbo.SALESLINE.SALESID INNER JOIN dbo.INVENTTABLE ON dbo.SALESLINE.ITEMID = dbo.INVENTTABLE.ITEMID LEFT OUTER JOIN dbo.DIMENSIONS ON dbo.SALESLINE.DIMENSION2_ = dbo.DIMENSIONS.NUM WHERE (dbo.SALESTABLE.DIMENSION = @Region) AND (dbo.DIMENSIONS.DIMENSIONCODE = 1) AND WHERE (dbo.SALESTABLE.CREATEDDATE) BETWEEN @SDate AND @EDate Kiwi_Wizz

Two Where Clause... Remove one~~ Mark it as Answer if you find it correct~~

Hi Sandeep Yes your right , why cannot you have two WHERE clauses ? Kiwi_Wizz

Because to add more than one predicate you use the AND keyword rather than adding consecutive WHERE statements... this is by design in the SQL standard.