Hi all

I have 2 tables A & B as follows

Table A
1. emp_no
2. name

Table B
1. effective_date
2. event_sequence
3. eveny_type
4. salary

Table B is the career progression of employee.
One employee can have multiple records in table B and can have multiple records on same date.

I wish to join table A & B in such a way that it returns for each employee, the table B record for a given date with the highest sequence.

Your advice is truly appreciated

Thanks & Best Regards