[PHP-DB] SQL combine to summations queries?

[Bas Jobsen]

Hello,

I don't understand the following, who can help?

I have got two queries:
SELECT SUM(fielda) FROM table1
and
SELECT SUM(fieldb) FROM table2

I thought this would be the same as:
SELECT SUM(fielda.table1),SUM(fieldb.table2)   FROM table1, table2.
But, itn't, why?

Tnx,

Bas Jobsen


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