> To do what I think you are trying to do you would use something like:
> Select sum(table1.fielda),sum(table2.fieldb) from table1 LEFT JOIN table2
ON
> table1.id=table2.id;
> if table1.fielda has more rows.
> If table2.fieldb has more rows use:
the amount of rows is the same :)
> Select sum(table1.fielda),sum(table2.fieldb) from table2 LEFT JOIN table1
ON
> table1.id=table2.id;
>
> Hope that helps
Yes, it does, TNX!!!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]