Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql syntax
Message
From
16/04/2005 04:10:58
Bernhart Milcent
Amline S.A.
Oupeye, Belgium
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sql syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01005419
Message ID:
01005419
Views:
54
Hi,


i have :

Employee.dbf
horaire.dbf ( cpauseid AND cPauseId2 )

I want

SELECT Employee.cName , X.total => (sum of result(3)) 
cpauseid     cpauseid2      Result
14             0              1
0              14             1
0              0              0
14             14             1
How can i do it please ( VFP 9 )


Thank in advance

bernhart
Next
Reply
Map
View

Click here to load this message in the networking platform