salut, asa nu merge?

 SELECT     nr_inreg, MAX(data_inreg) AS data, tip AS tip
FROM         dbo.Table2
GROUP BY nr_inreg, tip
HAVING      (tip IS NULL) AND (MAX(data_inreg) < CONVERT(DATETIME, '2007-07-26 00:00:00', 102))

 alex.