Hi Noel,

Your select looks correct to me. I think you hit a bug. What SQL Server version are you using? Do you've all SP's applied?
Check also FIX: Error 8623 is Raised When SQL Server Compiles a Complex Query mskb #816440.

>Hi to all
>
>I have a View and it executes well,
>Here is the Code:
>
<snip>
>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