Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cross Tables and syntax sql
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cross Tables and syntax sql
Miscellaneous
Thread ID:
00950444
Message ID:
00950444
Views:
76
Bonjour à tous(tes),
Hi all,

We Have :

Employe.dbf
Cnom c(30)
iid i

Horaire.dbf
iid i
ddate d
iemployeeid i
ipauseId i
nheures1 n(7,3)
cTaux1 c(3)
nheures2 n(7,3)
cTaux2 c(3)

Pause.dbf
cnom C(3)
iid i


We Wants a table ( or cursor ) with per day(horaire.iid ) and employee(iemployeid)

1) the name of Pause.cnom

2) The SUM( nHeures1 )
3) The SUM ( nHeures2 )

How can i have that ?

thank in advance

Sorry for my poor English...


Bernhart
Next
Reply
Map
View

Click here to load this message in the networking platform