>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.

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

Cetin