[SQL] Sumowanie wyniku kilku zapytań, użycie UNION Opcje

[rufuspl]

Cześć.
Mam taki problem, że łącząc/sumując trzy zapytania używając UNION w wyniku otrzymuję wynik niepołączony - powtarzają się kody procedur.

Oto moje zapytanie:

[SQL] pobierz, plaintext 
$zapytanie_icd9="SELECT `procedura1`, count(`procedura1`) as liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura1`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do'
						GROUP BY `procedura1`
						UNION
						SELECT `procedura2`, count(`procedura2`) as liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura2`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do'
						GROUP BY `procedura2`
						UNION
						SELECT `procedura3`, count(`procedura3`) as liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura3`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do'
						GROUP BY `procedura3`
						";
[SQL] pobierz, plaintext 

Jak połączyć wyniki tych zapytań tak, aby wyświetlały się unikatowe kody procedur?

[rufuspl]

[SQL] pobierz, plaintext 
$zapytanie_icd9="SELECT * FROM (
						SELECT `procedura1` AS `procedura`, count(`procedura1`) AS liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura1`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do'
						UNION
						SELECT `procedura2` AS `procedura`, count(`procedura2`) AS liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura2`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do'
						UNION
						SELECT `procedura3` AS `procedura`, count(`procedura3`) AS liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura3`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do') GROUP BY `procedura`
						";
[SQL] pobierz, plaintext 

Powyższe zapytanie daje pusty wynik

[SQL] pobierz, plaintext 
$zapytanie_icd9="SELECT * FROM (
						(SELECT `procedura1` AS `procedura`, count(`procedura1`) AS liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura1`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do')
						UNION
						(SELECT `procedura2` AS `procedura`, count(`procedura2`) AS liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura2`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do')
						UNION
						(SELECT `procedura3` AS `procedura`, count(`procedura3`) AS liczba FROM `opis` 
						left join `pacjent` using (id_pac)
						where `opis`.`procedura3`!='' AND `pacjent`.`id_ksiegi`=3 AND `pacjent`.`w_status`=1 AND `pacjent`.`czy_usuniety`=0
						AND `pacjent`.`data_zab`>='$stat1_data_od' AND `pacjent`.`data_zab`<='$stat1_data_do')) GROUP BY `procedura`
						";
[SQL] pobierz, plaintext 

Dodanie nawiasów (jak powyżej) nic nie zmienia - pusty wynik.
Coś źle robię?