cancellare record non referenziati

[RoBYCoNTe]

SELECT TAB1.Desc, ISNULL(TAB2.ID,'Non presente)
FROM Tabella1 as TAB1
LEFT JOIN Tabella2 as TAB2
ON TAB1.ID = TAB2.ID