Locate same or changed values

[Nathan01]

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 AC
1 1/1/2010 $5000 012 4444444
5 2/1/2010 $25000 012 4444444
7 3/1/2010 $5666 111 456789

[johny10151981]

You cannot get a built in solution.

but you can follow some strategy
such as:
1. Forbid deleting payment record. (If you allow its a violation of accounting)
2. Forbid editing payment record.(its a violation of accounting)

Now if they are not a big deal:
then when you delete do not delete the actuation record use another column to figure out whether it is deleted or not.
And When you edit make a record of original account row. create a backup, keep track of the editor.

but if you ask about deleting from original table manually, by manually I mean using other database client like phpmyadmin, mysql_client or other things then nothing to say

[Nathan01]

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.

[johny10151981]

Well in that case when you get a request to change the bank account, or when you receive a new transaction request a update then take an immediate look at previous transactions, if you found a new Bank account make a record to other table from where you can verify