You're right. I hope this is better....

Say I have 
two tables:

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


Stock:
Manufacturer    Model &
nbsp;      Number In 
Stock
=========      &
nbsp;=====        
===========
Ford     &n
bsp;      Fairmont     
31
Porsche         911&nb
sp;         
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
=========   &n
bsp;        
=========       &nbs
p;    
===========      
====
Ford         
;        29   &nbs
p;            
;   31               
60
Chevy          &n
bsp;      
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.

-- 

H²