append query

[mjernigan]

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.

[ck9663]

Assuming you're getting all PAID records for this day:

SELECT * FROM YOURTABLE1 where paydate = getdate() and paycode = 'PAID'
union all
SELECT * FROM YOURTABLE2 where paydate = getdate() and paycode = 'PAID'

I don't know your table structure, so that's just a pseudo-code.

Happy Coding!!!

~~ CK