Hello People
I should have the count from 3 tables in one query; something like this:
select count(*) from table1 union select count(*) from table2 union select
count(*) from table3 union;
The Problem ist, that the query gives 3 results back (the count from table1,
table2 and table3) BUT I should have only one result, the added value from
all 3 tables...
How can I do this within MySQL? Are there variables I could use within the
query? Other possibilities?
Thank you for your help!
Kind Regards,
Martin Rytz