Max's Query

OuterApply.sql

with LatestComments as (
	select 
		c1.ClaimNumber
	,	commentClaimId = c2.ClaimNumber
	,	co.PV_Message
	,	co.PV_ComlogDate
	,	rn = row_number() over (partition by c1.ClaimNumber order by co.PV_ComlogDate desc)
	from tbl_Accounts_Charges c1
	 join tbl_Accounts_Charges c2
	   on c2.AccountNumber = c1.AccountNumber
	 join tbl_MSI_Comlog_Backload2 co
	   on co.PV_ClaimNumber = c2.ClaimNumber
	) c
)
select *
from LatestComments
where rn = 1;