Say I have two tables:

Sales:
Manufacturer        Model        Number sold
=========        =====        ========
Ford                    F10            16
Ford                    Model T     13
Chevy                  Nova          2
VW                     Golf            3
VW                     Beetle         712


Stock:
Manufacturer        Model        Number In Stock
=========        =====        ===========
Ford                    Fairmont        31
Porsche                911               99
Renault                 Le Car          1
Cadillac                El Dorado     2
VW                      Square Back 71

I would like to combine this data with a query for results like:

Manufacturer            Number Sold            Number in Stock    Total
=========            =========            ===========      ====
Ford                         29                            31 
60
Chevy                       2                              0 
2
etc...

This isn't the real data, of course, just a similar example. I am just a 
little fuzzy on how to get this together on SQL. Anyone have any pointers? 
Muchas Gracias.

-- 

Post a reply to this message