UNION - nic nie rozumiem! Opcje

[axeld]

mam cos takiego:

select 1
union
select 2
union
select 3

kiedy kazdy select uruchamiam osobno to suma rekordow jest 128
ale kiedy wykonam wszystkie 3 selecty z unionami to mam 104 wyniki.

co sie dzieje? powinno tez byc 128 !?



wklejam ten select - jest dosc skomplikowany, ale poszczegolne selecty testowalem i chodza bardzo dobrze, a wspolnie nie.

[SQL] pobierz, plaintext 
SELECT pk_user AS user, date(pk_data) AS DATA, 'p' AS trening FROM dart_punkty GROUP BY date(pk_data), pk_user 
UNION
SELECT pk_user AS user, date(pk_data) AS DATA, 'b' AS trening FROM dart_bulls GROUP BY date(pk_data), pk_user 
UNION
SELECT zeg_user AS user, date(zeg_data) AS DATA, zeg_typ AS trening FROM dart_zegary GROUP BY zeg_sesjaid, zeg_user 
 
 
ORDER BY DATA DESC
[SQL] pobierz, plaintext 

[nospor]

pewnie ciezko zajrzec do manuala
http://dev.mysql.com/doc/refman/5.0/en/union.html
?

The default behavior for UNION is that duplicate rows are removed from the result. The optional DISTINCT keyword has no effect other than the default because it also specifies duplicate-row removal. With the optional ALL keyword, duplicate-row removal does not occur and the result includes all matching rows from all the SELECT statements.