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 ResultsIt throws a compile time error on the JOIN line.