Found it.

WHERE clause was before the JOIN.


>It's Monday morning and I'm just not seeing it.
>
>What's wrong with this command?
>
>

>SELECT * ;
>  FROM BSpotLn l;
>  WHERE l.statname = "KEVU" AND ;
>        BETWEEN(l.WeekOf, {10/31/05}, {11/27/05}) AND ;
>	l.ClientId = "PPC" AND ;
>	l.RecType = "A" AND ;
>	d.RecType = "A" ;
>  JOIN BSpotDt d ON d.BoIdBase = l.BoIdBase ;
>  INTO CURSOR Results
>

>
>It throws a compile time error on the JOIN line.