SELECT [AuditID]
      ,[ContentID]
      ,[Number]
      ,[Text]
      ,[Type]
      ,[FormatID]
      ,[Config]
      ,[DTS]
      ,[UserID]
      ,[DeleteStatus]
,DeleteDTS
  FROM [VEPROMS_JCB1].[dbo].[ContentAudits]
where (Number is not null)-- or (Contentid not in (select contentid from contents))
UNION
SELECT 0 [AuditID]
      ,[ContentID]
      ,[Number]
      ,[Text]
      ,[Type]
      ,[FormatID]
      ,[Config]
      ,[DTS]
      ,[UserID]
      ,[DeleteStatus]
,DeleteDTS
  FROM [VEPROMS_JCB1].[dbo].[tblContents]
WHERE DeleteStatus = 0 AND 
ContentID in
(
SELECT [ContentID]
  FROM [VEPROMS_JCB1].[dbo].[ContentAudits]
)
order by DTS,DeleteDTS