I am having an issue and i am not sure the best way to deal with it. The solution should be easy but i am just having a brain freeze.
So when a Tap Number is created it has a ALLOW_AMOUNT and is stored in one table. Once the TAP_EVENT is approved that ALLOW_AMOUNT becomes and AUTHORIZED AMOUNT and the record is removed and stored in a separate table. Unless of course there is a bug in the system that every once in a while doesn't do what it is supposed to do (as in record 21003500) where it copies to the new table but doesn't delete out of the old one [:@]. So when I concatentate and try to get a total "Amount" of both ALLOW_AMOUNT and AUTHORIZED AMOUNT 21003500 is approx double what it should be. If there is an Autorized Amount i just want that and the ALLOW_AMOUNT should be deleted.
They are two separate table that are just being concatenated nothing else. I have tried WHERE NOT EXISTS(TAP_EVENT_NUMBER) but the problem is that sometimes a TAP_EVENT can be divided into approved and none approved PACK_GROUP_IDs.
