Using the following Select Statement, I see all active drivers with a Credit Card Number :
SELECT top 1000 *
WHERE crd_status = ‘A’
Based on that query, I get a table with a bunch of columns. The column I’m focused on is the first one titled “crd_cardnumber” which is a list of credit card numbers that are associated with people that are active in our database. This is connected to our inhouse database and we have an application that will run an automated query. I just need to create a select statement that will return “What has changed” in the “crd_cardnumber” column when I run it.
Can anyone help me out?
Thank you so much!