When values are Null

[srideout2525]

I'm trying to make a query where I sum the rates in an order and sum the additional costs in an order. Unfortunately when there are no additional costs in the order the query leaves that order out. so for example

Order 1 has rate 200, 300 and costs 40 and 50

so i group by order# and sum the rates and the costs

Order 1 rate total 500 cost total 90.

in order 2 rate 200 and 400 and no related costs

the order will not show in my query?

How come? any help? I tried put NZ around the value, but that doesnt work. (i dont believ that is the correct use of NZ anyway..however)

Any help? Thx

 

[srideout2525]

Actually I think I'm wrong. I did the simplest of queries, return ONLY the order number, but not all my orders return?!?!?!?


HELP..I'm confused

 

[srideout2525]

Ok, no I'm not talking to myself...but, it appears as though it has to do with the inner join..and relates to what i first said.

 

[srideout2525]

Ok so i talked myself through it. Actually someone in my office helped out. It was a LEFT JOIN that worked. I was using an INNER JOIN. So I basically learned the difference in JOINS.