Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Synthaxe SQL
Message
From
17/12/2004 08:20:31
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969990
Message ID:
00970012
Views:
26
This message has been marked as the solution to the initial question of the thread.
SELECT cnosecretaraitSocial,COUNT(cnosecretaraitSocial) AS cntSoc FROM Employee GROUP BY cnosecretaraitSocial INTO CURSOR cSocial
SELECT cNom,cnosecretaraitSocial,cSocial.cntSoc;
       FROM Employee;
       LEFT JOIN cSocial ON cnosecretaraitSocial == cSocial.cnosecretaraitSocial; 
       GROUP BY cNom
Is this works for You?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform