Re: Multiple table count in one sql-query

2004-11-24 Thread Rhino
- 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 like this: select count(*) from

RE: Multiple table count in one sql-query

2004-11-24 Thread Guillaume Giroux
(@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

Re: Multiple table count in one sql-query

2004-11-24 Thread Michael Stassen
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 like this: select count(*) from