The Id maybe someones name. So what i am trying to do is identify when a customers bank account is changed at the individual transaction level. The bank account is allowed to be changed, however i want to identify it when it occurs as a potential fraud check.
Also for internal fraud purposes i want to identify if two customers have the same bank account.
Nathan01
Last Activity: Dec 14 '11, 04:42 AM
Joined: Dec 14 '11
Location:
-
Locate same or changed values
I would like to write a query to identify when an EFT/Direct Deposit transactions bank account details (BSB, AC) change when the identifier (iD) remains the same, ie
iD DatePaid AmountPaid BSB AC
1 1/1/2010 $5000 012 4444444
1 2/1/2010 $25000 012 4566657
I would also like to identify when different iDs have the same BSB and AC, ie
iD DatePaid AmountPaid BSB...
No activity results to display
Leave a comment: