Baranowski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 8:39 AM
Subject: Re: Count Rows in two tables
Please forgive me I am new to mySQL, could you give me an example of how I
would do this? The two tables are users and staff
Thanks
Rick
- Original Message
the error
let me know and I will send it to you.
Thanks again
- Original Message -
From: Shyamal Banerjee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 4:29 AM
Subject: Re: Count Rows in two tables
If you know the primary keys of the two tables, it may be done
Hello all,
Does anybody have a SQL string to count the rows in two different tables and
give you a total number of rows? I have been trying to find an answer for a
couple of days and seems like a simple string.
Thank you
Rick
You can't count the join?
Alan
-Original Message-
From: Rick Baranowski [mailto:rickb;baranconsulting.com]
Sent: Wednesday, 13 November 2002 12:10
To: [EMAIL PROTECTED]
Subject: Count Rows in two tables
Hello all,
Does anybody have a SQL string to count the rows in two
On 11/12/02 5:36 PM, Alan McDonald [EMAIL PROTECTED] wrote:
You can't count the join?
Alan
Hello all,
Does anybody have a SQL string to count the rows in two different
tables and
give you a total number of rows? I have been trying to find an
answer for a
couple of days and seems like
Does it have to be in a single query. You could use a Union query and
then total the results in your program.
Select Count(Field1)
From Table1
Union Select Count(Field1)
From Table2;
Rick Baranowski [EMAIL PROTECTED] 11/12/02 5:10:14 PM
Hello all,
Does anybody have a SQL string to count
To: [EMAIL PROTECTED]
Subject: Count Rows in two tables
Hello all,
Does anybody have a SQL string to count the rows in two different
tables and
give you a total number of rows? I have been trying to find an
answer for a
couple of days and seems like a simple string.
Thank you
Ah, yes - sorry
Alan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:murad;godel.bioc.columbia.edu]On Behalf Of Murad Nayal
Sent: Wednesday, 13 November 2002 12:58
Cc: [EMAIL PROTECTED]
Subject: Re: Count Rows in two tables
Alan McDonald wrote:
You can't count
2002 12:10
To: [EMAIL PROTECTED]
Subject: Count Rows in two tables
Hello all,
Does anybody have a SQL string to count the rows in two different
tables and
give you a total number of rows? I have been trying to find an
answer for a
couple of days and seems like