Zliczanie rekordów z 3 tabel Opcje

[the-sopel]

Witam, musze zliczyć rekordy z 3 baz, napisałem coś takiego (niestety nie działa, wyświetla 1)

[SQL] pobierz, plaintext 
SELECT count(v.id) AS news, count(f.id) AS arts, count(g.id) AS files FROM news v, articles_arts f, download_files g GROUP BY v.id, f.id, g.id
[SQL] pobierz, plaintext 

Proszę o pomoc i pozdrawiam.

[Adiasz]

[SQL] pobierz, plaintext 
SELECT count(id) FROM news UNION
SELECT count(id) FROM articles_arts UNION
SELECT count(id) FROM download_files
[SQL] pobierz, plaintext 

albo:

[SQL] pobierz, plaintext 
SELECT count(id),(SELECT count(id) FROM articles_arts),(SELECT count(id) FROM download_files) FROM news
[SQL] pobierz, plaintext