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

Reply via email to