Ajout dans un critère
Date: mercredi 3 décembre 2008 14:03:39
Bonjour,
comment ajouter dans ce prédicat:
* Member list by pool
SELECT
last_name AS Lastname,
first_name AS Firstname,
DATE_FORMAT(subscription, '%d %m %Y' ) AS Date,
member_pool.name AS Pool
FROM authentication
LEFT JOIN member ON member.id = authentication.id
LEFT JOIN member_pool_join ON member_pool_join.member_id = member.id
LEFT JOIN member_pool ON member_pool.id = member_pool_join.member_pool_id
WHERE YEAR(subscription) >= $year
ORDER BY Pool, Lastname, Firstname
l'adresse complète de membres (address, zipcode et city)?
et dans celui-ci Hdv par pilote:
SELECT
CONCAT(last_name,' ',first_name) AS Nom,
IF (( SELECT
COUNT(*)
FROM flight_pilot fp2
WHERE fp2.flight_id=fp.flight_id AND fp2.num=1)=0,
'Solo',
'double') AS Solo_DC,
CONCAT(FLOOR(SUM( flight.duration )/600),':',TIME_FORMAT(SEC_TO_TIME((SUM( flight.dur
ation )/600 - FLOOR(SUM( flight.duration )/600))*3600),'%i')) AS Total
FROM flight_pilot fp
LEFT JOIN flight ON fp.flight_id=flight.id
LEFT JOIN authentication a ON a.id=fp.pilot_id
WHERE YEAR( start_date ) = $year AND fp.num=0
GROUP BY Nom, Solo_DC
un classement par groupe?
Merci
Seb VITTOZ - Admin CAPAM
Modifié 1 fois. Dernière modification le 03/12/08 14:10 par seb.