I am trying to write a simple SQL query that sums a salesman sales by month, but the date seems to be my trouble.
What I need to see is summed sales by salesman for a particular month/year 11-2013
FROM oehdrhst_sql HDR
INNER JOIN oelinhst_sql LIN ON
GROUP BY HDR.slspsn_no
As the above is written I get (0 row(s) affected)
Any help would be much appreciated