Show sum based on criteria, but show all rows independent of criteria

[AccessTheBase]

For each product in the database,


I want to show sum(order value)
Where Country = "Germany"

BUT I want to show all product rows, also those with no revenue in Germany. How can I accomplish this?

Product1 | 51264
Product2 |
Product3 | 1215
Product4 |
Product5 |

[Bob Fitz]

Can you tell us a little more ablut your table structure.

I would expect you to have at least 3 tables (Sales, Products, Countries)
If this is correct can you tell the names of the tables and related fields.

If this is NOT correct can you tell us what you do have.