3 zapytania do 1 tabeli - scalenie do 1 zapytania Opcje

[Ryder]

Witam

Mam takie 3 zapytania: (1 tabela)

[SQL] pobierz, plaintext 
SELECT count(id) AS ok FROM comments WHERE receiver_id = '10' AND reference = 'positive', 
SELECT count(id) AS nok FROM comments WHERE receiver_id = '10' AND reference = 'negative', 
SELECT count(id) AS comments FROM comments WHERE receiver_id = '10' AND comments IS NOT NULL
[SQL] pobierz, plaintext 

Chciałbym zrobic z tego 1 zapytanie, które zwróciły 1 wiersz z 3 wartosciami ok, nok, comments.
W jaki sposób najlepiej to zrobic?

Juz nieaktualne . Znalazłem rozwiazanie

[SQL] pobierz, plaintext 
SELECT count( DISTINCT IF( reference = 'positive', ID, NULL ) ) , count( DISTINCT IF( reference = 'negative', ID, NULL ) ) , count( DISTINCT IF( comments IS NOT NULL , ID, NULL ) )
FROM meeting_comments WHERE receiver_id = '10'
[SQL] pobierz, plaintext 

Ten post edytował Ryder 30.11.2012, 19:08:39