Peso,

Does your script (full join) show the "Add", "Delete", "Change"?

In the delta report table, probably need one status column (its value can be like "Add","Delete", "change-Old", "change-New".

For the changed...

Thanks a lot for the comments. I agree with one-table with date as a column. It is really hard to maintain that many tables.

The inventory for one customer is at...