DELETE
[liaison].[dbo].[LI_ENT_Entry],
[liaison].[dbo].[LI_ENT_AppEntry],
[liaison].[dbo].[LI_ENT_AppEntryLink]

FROM
[liaison].[dbo].[LI_ENT_Entry]

INNER JOIN
[liaison].[dbo].[LI_ENT_AppEntry]
ON
[liaison].[dbo].[LI_ENT_Entry].[ID] = [liaison].[dbo].[LI_ENT_AppEntry].[LI_ENT_Entry__ID]

LEFT JOIN
[liaison].[dbo].[LI_ENT_AppEntryLink]
ON
[liaison].[dbo].[LI_ENT_AppEntry].[ID] = [liaison].[dbo].[LI_ENT_AppEntryLink].[LI_ENT_AppEntry__ID_Child]

WHERE
[liaison].[dbo].[LI_ENT_Entry].[PrimaryLangName] = 'Hamers, Patrick'