subject:"RE\: Multiple table count in one sql\-query"

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(*)

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 > > >

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(*)