Oh, by the way...

I'm not sure if this operator (=*) will work within any DB or I have to use Right or Left Join terms?

I was testing it on...

Thank you very much for helping me.

Here is what I eneded up with and it works as it should:

SELECT Year(date_shipped) as sales_year, sum(qty_ordered) as total_orders, sum(qty_shipped) as total_shipped, sum(price*qty_ordered) as...