Hello,
TRAININGS(ID_TR AINING, TRAINING_NAME)
HOSTED_TRAINING S(ID_HOSTED_TRA INING, ID_TRAINING, DAYS)
EMPLOYEES_ON_TR AININGS(ID_HOST ED_TRAINING)
What I want to do is a querry with sum of days and number of employees for each training
Tried something like that but it returns error "ID_HOSTED_TRAI NING is not a part of aggregate function" or something like that:/
[CODE=SQL]SELECT s.TRAINING_NAME AS Szkolenia, Sum(ps.DAYS), (SELECT COUNT(*) FROM EMPLOYEES_ON_TR AININGS as pns WHERE pns.ID_HOSTED_T RAINING = ps.ID_HOSTED_TR AINING)
FROM TRAININGS AS s, HOSTED_TRAINING S AS ps
WHERE (s.ID_TRAINING = ps.ID_TRAINING)
GROUP BY s.TRAINING_NAME
ORDER BY s.TRAINING_NAME ;[/CODE]
I also tried to write COUNT function without SELECT statemant but then it counts days wrong :/
Any ideas?
TRAININGS(ID_TR AINING, TRAINING_NAME)
HOSTED_TRAINING S(ID_HOSTED_TRA INING, ID_TRAINING, DAYS)
EMPLOYEES_ON_TR AININGS(ID_HOST ED_TRAINING)
What I want to do is a querry with sum of days and number of employees for each training
Tried something like that but it returns error "ID_HOSTED_TRAI NING is not a part of aggregate function" or something like that:/
[CODE=SQL]SELECT s.TRAINING_NAME AS Szkolenia, Sum(ps.DAYS), (SELECT COUNT(*) FROM EMPLOYEES_ON_TR AININGS as pns WHERE pns.ID_HOSTED_T RAINING = ps.ID_HOSTED_TR AINING)
FROM TRAININGS AS s, HOSTED_TRAINING S AS ps
WHERE (s.ID_TRAINING = ps.ID_TRAINING)
GROUP BY s.TRAINING_NAME
ORDER BY s.TRAINING_NAME ;[/CODE]
I also tried to write COUNT function without SELECT statemant but then it counts days wrong :/
Any ideas?
Comment