I work for an insurance payor and I am trying to come up with a SQL script that will provide appended data from 2 different Unix based tables. I would like to be able to select only changed/updated data (pay date will be used as the variable) from those tables while separating into one of 4 catagories (paid, held, void or suspended) depending on the pay code.
Is there anyone out there who can possibly help me?

Mike J.