Polaczenie 2 zapytan, 2 x count :| Opcje

[orson]

witam ...

mam takie 2 zapytania:

[SQL] pobierz, plaintext 
SELECT count(t1.PersonID) AS zaproszeni, t1.PersonID, t1.Fname, t2.Fname
FROM sys_persons AS t1, sys_persons AS t2 WHERE t1.PersonID = t2.InvitedBy
GROUP BY t1.PersonID
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT count(DISTINCT t2.DocID) AS prace, t1.PersonID, t1.Fname
FROM sys_persons AS t1, sys_docs AS t2 WHERE (t1.PersonID = t2.AuthorID) AND t1.PPCredit != 0
GROUP BY t1.PersonID
[SQL] pobierz, plaintext 

czy da sie je polaczyc w 1 rozwiazanie z 2 zapytaniami jest zle ... poniewaz zapytania moga zwracac rozna ilosci wierszy ... moze byc problem z laczeniem wynikow ... pobierane sa te same dane ale inny count ... probowalem z joinami [left, right, cross. outer] ale nie chce mi wyjsc ... czy polaczenie tego jest mozliwe

aha... mysql w wersji 4.0.x ... bez podzapytan ...

pozdrawiam

[bigZbig]

Wyprobuj

[SQL] pobierz, plaintext 
SELECT count(t1.PersonID) AS zaproszeni, t1.PersonID, t1.Fname, t2.Fname, count(DISTINCT t2.DocID) AS prace, t1.PersonID
FROM sys_persons AS t1, sys_persons AS t2, sys_persons AS t3 
WHERE t1.PersonID = t2.InvitedBy AND t1.PersonID = t3.AuthorID AND t1.PPCredit != 0
GROUP BY t1.PersonID
[SQL] pobierz, plaintext 

Ten post edytował bigZbig 9.12.2004, 15:18:07