I need to select and compare a value in 2 different tables but I am not sure of the best method to do this. I am an attorney and I represent clients who were injured at work (workers compensation). I have one table that has the date of accident and the amount of clients weekly earnings. The second table shows the maximum amount that an injured worker can be paid per week for each year (when a person gets hurt on the job and can not work in my state they are entitled to receive a certain amount of money until they can go back to work). The idea is to compare the clients' AWW on the date of accident to the maximum the law allows for payments to an injured worker in the year of that accident shown in the second table. For example: Joe has an accident at work in the year 2000. He makes $300 per week before his accident and the law allows him get $300 each week. But if in the year 2000, the law places a maximum cap of how much an injured worker can get paid to say... $175 , then he can only get that much. If the cap for year 2000 is $300 or greater he can get what he used to make. The tables look like this:
Table 1
ClientName
DateOfAccid
AWW
Table 2
Date
Maximum
Any help is appreciated.