Hi Jeff. Thanks for the example. It works well. I read through the articles you suggested. And now have a much better understanding of what's required and where you guys...

Can anyone help show me the SQL required to reslove my issue? I've never used an OUTER APPLY before.

Appreciated.

Not quite sure I follow. Can you provide the SQL statements required for your two recommended solutions?

Thanks.

The issue is when I try to run statement:

SELECT PWARD_EQUIPMENT.EQUIPMENT_ID, PWARD_EQUIPMENT.AMMO_QUANTITY AS QUANTITY_ON_HAND,

SUM(PWARD_AMMO_USE_EQUIPMENT.QUANTITY_USED) AS QUANTITY_USED, SUM(PWARD_EQUIPMENT.AMMO_QUANTITY + QUANTITY_USED) AS QUANTITY_RECEIVED

FROM ...

Thanks alot. Much appreciated.

Do you have a sample that I can review?

Thanks, appreciated.