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