Sasha Pachev wrote:
Gustavo Andrade wrote:
I want to know if its possible to count the total records of multiple
tables:
Example: I have 3 tables. I want to know the total records of each table
using only 1 query.
Is that possible?
It is actually possible with 4.0, although rather convoluted:
(se
At 21:17 -0600 5/17/04, Sasha Pachev wrote:
Gustavo Andrade wrote:
I want to know if its possible to count the total records of multiple
tables:
Example: I have 3 tables. I want to know the total records of each table
using only 1 query.
Is that possible?
It is actually possible with 4.0, although
Gustavo Andrade wrote:
I want to know if its possible to count the total records of multiple
tables:
Example: I have 3 tables. I want to know the total records of each table
using only 1 query.
Is that possible?
It is actually possible with 4.0, although rather convoluted:
(select count(*) from f
.
>
>
>> -Original Message-
>> From: Gustavo Andrade [mailto:[EMAIL PROTECTED]
>> Sent: Sunday, May 16, 2004 3:10 PM
>> To: [EMAIL PROTECTED]
>> Subject: Counting multiple tables
>> I want to know if its possible to count the total records of multip
> Sent: Sunday, May 16, 2004 3:10 PM
> To: [EMAIL PROTECTED]
> Subject: Counting multiple tables
>
> I want to know if its possible to count the total records of multiple
> tables:
> Example: I have 3 tables. I want to know the total records of each table
> using only
I want to know if its possible to count the total records of multiple
tables:
Example: I have 3 tables. I want to know the total records of each table
using only 1 query.
Is that possible?
_
Quer ter um fórum para seu clan de Starcraft/BroodWar, C
Hi,
I'm trying to do a SELECT which then counts records in two separate
tables, eg:
SELECT a_id, count(b_id) FROM a LEFT JOIN b USING(a_id)
merged with
SELECT a_id, count(c_id) FROM a LEFT JOIN c USING(a_id)
So you would end up with
a_id, count(b_id), count(c_id)
Showing the number of records l
