Difficult SQL Statement

[fletch1024]

I have a database with 2 tables consisting of:

table1:
unique_id
lic_manufacturer
lic_product_name
lic_qty

table2
unique_id
soft_manufacturer
lic_product_name
soft_qty

I need to write a sql statement that will output lic_manufacturer,
lic_product_name, the sum of lic_qty for each lic_product_name, and the the sum of soft_qty for each lic_product_name.

That way I can just dump it out to HTMl to compare it how much software is installed vs how many licenses there are.

I have tried writing a statement that joins the tables, but because both tables have different #s of entries, the resulting table gets hosed. Does anyone have any ideas?

Setup is as follows:
PHP 4.?
Mysql 4.0
Apache 2.0

[LordShryku]

Think you need a left join then.

May need to add the manufacturer to the group by, but

SELECT    a.lic_manufacturer,
          a.lic_product_name, 
          sum(a.lic_qty) AS lqty
          sum(b.soft_qty) AS sqty
FROM      table1 a
LEFT JOIN table2 b
ON        a.unique_id = b.unique_id
GROUP BY  a.lic_product_name

[fletch1024]

Thanks, I will try that.