[snip]
I have 2 tables, identical in fields. One is an 'archived items' table,
the
other is a live items.
[/snip]
Are they also identical in record count?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mike Morton wrote:
I have 2 tables, identical in fields. One is an 'archived items' table, the
other is a live items.
I want to run a query that will grab the sum of all products in both tables,
like:
The results would display the total qty by item:
QTY NAME
The logic is something like:
[snip]
No, they have different record numbers...
[/snip]
a. Always reply to the list. I just happened to spot this in my spam
folder while cleaning.
2. You're getting Cartesian results, so your query needs to be a little
more specific
Your original query --
select (sum(table1.qty) +