the two tables, it may be done as follows:
>
> select count(distinct t1.pk1) + count(distinct t2.pk2) from t1,t2;
> where - pk1 is the primary key column name of table t1 and
> pk2 is the primary key column name of table t2.
>
> SB
> - Original Message -
> From: &q
ubject: Re: Count Rows in two tables
>
> Alan McDonald wrote:
> >
> > You can't count the join?
> > Alan
>
> if you count the (unqualified) join you'll end up with the product of
> the two table counts.
>
> Murad
>
> >
> > >
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
