Nested Queries

SELECT
	NestedA.ColName1
	B.ColName1
FROM (
	SELECT 
		A.ColName1,
		A.SomeId,
		ROW_NUMBER() OVER (
			PARTITION BY A.SomeId ORDER BY A.SomeDate DESC
		) AS MostRecentDate
		FROM SchemaName.TableA AS A
) NestedA
	LEFT JOIN SchameName.TableB AS B
		ON NestedA.SomeId = A.SomeId
	WHERE MostRecentDate = 1