View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Join between tables - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

  
 

Planifiez avec ProjeQtOr

15 et 16 avril 2025 (9h-12h30)

14 et 15 mai 2025 (9h-12h30)

  
 

Administrez avec ProjeQtOr

23 et 24 avril (9h-12h30)

20 et 21 mai (9h-12h30)

  

 

 

Join between tables

More
27 Mar 2013 11:25 #1 by imenkolsi
Join between tables was created by imenkolsi
Hi again,
I'de like to join between n tables

I want to do with just one query that will returns all the result


For example between the table resource and the table work

i'd like to get for each resource its work


I don't want to have many queries : one to get all the resources and another query to

get the work for each one.


Would u help me ?

Please Connexion or Create an account to join the conversation.

More
27 Mar 2013 11:30 #2 by babynus
Replied by babynus on topic Re: Join between tables
Something like this ?
select resource.fullname, sum(work.work)
from resource, work
where resource.id=work.idResource
group by resource.fullname
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
27 Mar 2013 11:39 #3 by imenkolsi
Replied by imenkolsi on topic Re: Join between tables
Actually i'm looking for something like this

SELECT r.id, r.fullname, r.email, w.work
FROM resource r
LEFT JOIN WORK w ON r.id = w.idResource
GROUP BY r.name

Could u tell me how can i get this one with one from your sql methods ?


other wise, can i use directly this query on the code ? if yes would u tell me

how ?

Please Connexion or Create an account to join the conversation.

More
27 Mar 2013 11:50 #4 by babynus
Replied by babynus on topic Re: Join between tables 
$query='SELECT r.id, r.fullname, r.email, w.work'
.' FROM resource r'
.' LEFT JOIN WORK w ON r.id = w.idResource'
.' GROUP BY r.name';
$result=Sql::query($query);
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
27 Mar 2013 12:01 #5 by imenkolsi
Replied by imenkolsi on topic Re: Join between tables
Thank you :) every thing works really fine

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.033 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form