|
![](/i/fill.gif) |
Halbert wrote:
> 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?
You want to look for "outer join" and "group by". Group each of the two
tables my manufacturer to SUM() up the number sold and number in stock, then
do an outer join on the manufacturer name (replacing NULL with 0 before
display).
--
Darren New, San Diego CA, USA (PST)
"We'd like you to back-port all the changes in 2.0
back to version 1.0."
"We've done that already. We call it 2.0."
Post a reply to this message
|
![](/i/fill.gif) |