Query

Question

How to write a query for audit table?

I have to get OLD_Value and NEW_Value

 

This is my table:

 

Tabel : 1

BusinessEntityID int PRIMARY KEY

RateChangeDate datetime

Rate money

PayFrequency tinyint------ > Have to change this column

ModifiedDate datetime

Tabel : 2

BusinessEntityID int PRIMARY KEY

Old_Value tinyint

New_Value tinyint

ModifiedDate datetime