I want to create a view and join two tables together on an identity field it’s a one to many relationship. Basically I have to do a right outer joint but the problem is I only want the record with the latest date in the second table.

For example
If this is the left table:
Identity info_1
1 yyy
2 zzz

Right table:
Identity date info_2
1 3/11/2001 aaa...