COUNT von mehreren Tabellen in einem Query

[Stevie]

Das geht so nicht! Guck dir mal an, wie Group Functions arbeiten.

Wenn, dann geht das so:

SQL-Code:

select 's2b_history' as Tabelle, count(*) as Anzahl from s2b_history
union
select 's2b_pic' as Tabelle, count(*) as Anzahl from s2b_pic
union
select 's2b_links' as Tabelle, count(*) as Anzahl from s2b_links