DECLARE @Enabled Bit DECLARE @Public Bit DECLARE @Public2 Bit SET @Enabled=1 SET @Public=1 SET @Public2=1 SELECT TOP 10 Class.Title,Class.Notes,Class.AddDate,Class.ModDate,Class.Numero FROM Class UNION ALL SELECT ClassMethod.Title,ClassMethod.Notes,ClassMethod.AddDate,ClassMethod.ModDate,ClassMethod.Numero FROM ClassMethod ORDER BY AddDate DESC