Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is wrong with this SELECT SQL?
Message
From
29/03/2006 07:40:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
What is wrong with this SELECT SQL?
Miscellaneous
Thread ID:
01108740
Message ID:
01108740
Views:
51
SELECT Invent.codigo, Productos.descrip, SUM(Invent.saldoenivel);
 FROM  sabia!invent INNER JOIN sabia!productos ;
   ON  Invent.codigo = Productos.codigo;
 WHERE SUM(Invent.saldoenivel) = 0;
 GROUP BY Invent.codigo;
 ORDER BY Invent.codigo
When I try to run a view based on this SQL I get a message "File 'sum.prg' does not exist"

Thank you in advance for your time
Next
Reply
Map
View

Click here to load this message in the networking platform