Rhino wrote:
- Original Message -
From: "Martin Rytz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 2004 8:47 AM
Subject: Multiple table count in one sql-query
Hello People
I should have the count from 3 tables in one query; something l
(@CNT:[EMAIL PROTECTED](*)) from table3)
ORDER BY 1 DESC LIMIT 1
GG
> -Original Message-
> From: Rhino [mailto:[EMAIL PROTECTED]
> Sent: November 24, 2004 09:47
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Multiple table count in one sql-query
>
>
>
- Original Message -
From: "Martin Rytz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 2004 8:47 AM
Subject: Multiple table count in one sql-query
> Hello People
>
> I should have the count from 3 tables in one query; someth
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 sh
