SQL Server 2012，选择两个最大记录然后加入

I'm trying to conduct a multi-table join that uses the common ScheduledObjectID field. I'd like to select multiple records from a table based on the max RunID and UserDueDate. Any help would be greatly appreciated.I'm trying to conduct a multi-table join that u