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