Code Snippet about T-SQL Query

select pl.Id as 'ID',
MyType =
case
		when exists (select * from [TestDB].[dbo].SomeTable fsl (nolock) where fsl.Id = pl.Id) then
		'Type1'
		else
		'Type2'
End
,
av.AttachmentId as 'Another ID',
Convert(varchar, av.DateLastUpdated, 101) as 'Date',
Convert(varchar, av.DateEntered, 101) as 'Date 2',
Address =
(select TOP 1
RTRIM(adr.Address1) + '' + COALESCE(adr.Address2,'') + ',' + adr.CityName + ',' + COALESCE(adr.CountyRegionName,'') + ',' + adr.StateProvCode + RTRIM(adr.PostalZipCode)as 'Address'
from [TestDB].[dbo].[TestDBAddress] as pladd (nolock)

inner join [TestDB].[dbo].[Address] as adr (nolock)

on pladd.AddressID = adr.AddressID
where pladd.Id = pl.Id)
from [TestDB].[dbo].[TestDB] as av (nolock)

inner join [TestDB].[dbo].[TestDB1] as pla (nolock)

on av.Id = pla.Id
where
and av.DateLastUpdated between '2014-05-01' AND '2014-05-31'