Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Command Error
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Command Error
Miscellaneous
Thread ID:
01087198
Message ID:
01087198
Views:
61
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.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform