Friday, February 17, 2012

Error sql reports

I keep getting an error around the where statement can some one help me Sql Reports what is missing

SET DATEFORMAT mdy
SELECT PAYER.PAY_COMPANY AS Company, PAYER.PAY_CITY AS Branch, DATEPART(yy, INVOICE_AR.INVOICE_DATE) AS OrderYear, 'Q' + DATENAME(qq, INVOICE_AR.INVOICE_DATE) AS OrderQtr

FROM PAYER INNER JOIN INVOICE_AR

WHERE (INVOICE_AR.INVOICE_DATE BETWEEN '1/01/2004' AND '12/31/2005')

GROUP BY DATEPART(yy, INVOICE_AR.INVOICE_DATE), PAYER.PAY_COMPANY, PAYER.PAY_CITY, 'Q' + DATENAME(qq, INVOICE_AR.INVOICE_DATE)

cpowers:

FROM PAYER INNER JOIN INVOICE_AR

You are doing a JOIN but you have not mentioned what columns you are joining on.

The syntax is

SELECT ...

FROM tableA

JOIN TableBON TableA.SomeColumn = TableB.SomeColumn

No comments:

Post a Comment