Hello Everyone -
I am working with two tables... The first one I am creating a temp table getting distinct dates based on some criteria from another table, the columns in the temp table would be:
a.EDate, a.PolNumber, a.CType
What I am trying to do is get the maximum date from another table that is not greater than EDate from the temp table.
Columns in that other table are:
b.VDate, b.PolNumber, b.CType, b.ChargeBack
I want the query to return:
a.EDate, a.PolNumber, a.CType, b.VDate (the last available date not greater than a.EDate), b.ChargeBack
a.PolNumber = b.PolNumber and a.CType = b.CType
Hope I explained it ok, thanks for the help!!