Open Leobouloc opened 6 years ago
Dans MySQL :
select user_id, email, count(*) as nb_projets from projects, users where projects.user_id=users.id group by user_id,email;
select user_id, email, project_id as projet_id from projects, users where projects.user_id=users.id;
Dans MySQL :
Nombre de projets par utilisateur
select user_id, email, count(*) as nb_projets from projects, users where projects.user_id=users.id group by user_id,email;
Liste des numéros de projets
select user_id, email, project_id as projet_id from projects, users where projects.user_id=users.id;