[SQL] Wyciagniecie unikatowego pola z bazy Opcje

[AndyPSV]

[SQL] pobierz, plaintext 
SELECT DISTINCT mail FROM biz_u,buzzpek_u,chcur_u,clubkr_u,cocain_u,comixxy_u,drug_u,investor_u,mha_u,power_u,redkr_u,xernt_u
[SQL] pobierz, plaintext 

nie dziala; tj

[HTML] pobierz, plaintext 
SQL 1052 :: Column 'mail' in field list is ambiguous
[HTML] pobierz, plaintext 

[nospor]

Walisz bezmyslnie te posty jeden za drugim, zamist spokojnie zajrzec do dokumetnacji :/

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.

Tak trudbno?