SELECT "P"."Id" "PatientId"
FROM "Patient" "P"
INNER JOIN (
	SELECT 
		"_PPFIS".*, 
		"_PP"."PatientId" "PatientId"
	FROM "ProcessPatientFamilyIncomeStatement" "_PPFIS"
	INNER JOIN "ProcessPatient" "_PP" ON "_PP"."Id" = "_PPFIS"."ProcessPatientId"
	WHERE "_PPFIS"."Id" = (
		SELECT TOP 1"__PPFIS"."Id"
		FROM "ProcessPatientFamilyIncomeStatement" "__PPFIS"
		INNER JOIN "ProcessPatient" "__PP" ON "__PP"."Id" = "__PPFIS"."ProcessPatientId"
		WHERE "__PP"."PatientId" = "_PP"."PatientId"
		ORDER BY "__PPFIS"."LastUpdateDate" DESC
	)
) "PPFIS" ON "PPFIS"."PatientId" = "P"."Id"