Hi to all

I have a View and it executes well,
Here is the Code:

SELECT A.SA_ID, A.SA_NAME, B.TOTALSALES, B.JO_SALES, 
    C.TOTALSERVICE, C.JO_SERVICE, 
    B.TOTALSALES + C.TOTALSERVICE AS TOTAL, 
    B.JO_SALES + C.JO_SERVICE AS TOTALJO
FROM tblSADVISORS A LEFT OUTER JOIN
        (SELECT SA_ID, SUM(PRICE * QTY) AS TOTALSALES, 
           COUNT(DISTINCT JO) AS JO_SALES
      FROM tblsales
      GROUP BY SA_ID) B ON 
    A.SA_ID = B.SA_ID LEFT OUTER JOIN
        (SELECT SA_ID, SUM(PRICE * QTY) AS TOTALSERVICE, 
           COUNT(DISTINCT JO) AS JO_SERVICE
      FROM tblSERVICES
      GROUP BY SA_ID) C ON A.SA_ID = C.SA_ID

the code is running perfectly but when I add a
WHERE CLAUSE inside the SubQUERY it will creates an error

Here is the code with WHERE CLAUSE:

SELECT A.SA_ID, A.SA_NAME, B.TOTALSALES, B.JO_SALES, 
    C.TOTALSERVICE, C.JO_SERVICE, 
    B.TOTALSALES + C.TOTALSERVICE AS TOTAL, 
    B.JO_SALES + C.JO_SERVICE AS TOTALJO
FROM tblSADVISORS A LEFT OUTER JOIN
        (SELECT SA_ID, SUM(PRICE * QTY) AS TOTALSALES, 
           COUNT(DISTINCT JO) AS JO_SALES
      FROM tblsales
      WHERE DATE BETWEEN '08/18/2003' AND '08/20/2003'
      GROUP BY SA_ID) B ON 
    A.SA_ID = B.SA_ID LEFT OUTER JOIN
        (SELECT SA_ID, SUM(PRICE * QTY) AS TOTALSERVICE, 
           COUNT(DISTINCT JO) AS JO_SERVICE
      FROM tblSERVICES WHERE DATE BETWEEN '08/18/2003' AND '08/20/2003'
      GROUP BY SA_ID) C ON A.SA_ID = C.SA_ID

SQL Error is:

   The Query Processor could not produce a query Plan.

Any Idea what I'm I doing wrong?

Noel