I have a table that has data for claims at different evaluation dates. There is a record as of 1/1/2010, then another record for 1/1/2011.
The common fields are claim_number, claim_id, and policy_number.
To be simple, let's say the table only has 4 columns. Claim_Number, Claim_Id, Policy_Number, and Total_Paid.
Can I take the record from 1/1/2010 and compare it to the record as of 1/1/2011 to see if the Total_Paid amount is different?