I have two temporary tables in a stored prcedure that is used for reporting for a project of mine. What I want to do is look through table A and for all recrods NOT in table B add a new record to show zero sales. What is the best way to accomplish this?

Thanks in advance
Kelly