I have 3 tables: tlog(autoid, namt, acctno), tlogA(autoid, namt, acctno) the different is tlog are transactions current day, and tlogA are transactions in past.
And a table EMP(empcd, name, salary).
I want to list each time increase salary transaction of employee with old salary, new salary, how much it increase.
Know that: NAMT is how-much-salary-increase
and ACCTNO is EMPCD
I'm very sorry for my poor english.