SELECT     dbo.DiaryDelegations.ACTIONID, dbo.DiaryDelegations.HANDLER, dbo.diary.CASECODE, dbo.matters.Code
FROM         dbo.matters RIGHT OUTER JOIN
                      dbo.diary ON dbo.matters.Code = dbo.diary.CASECODE RIGHT OUTER JOIN
                      dbo.DiaryDelegations ON dbo.diary.ACTIONID = dbo.DiaryDelegations.ACTIONID
WHERE     (dbo.matters.Code IS NULL)

delete diary where (select code from matters where code= diary.casecode) is null
delete diarydelegations where (select actionid from diary where actionid = diarydelegations.actionid) is null


~

'~'