select p.*, a.attrDescription as projectStatusText from tbl_RD_Projects p
inner join tbl_PRJ_Attributes a
on a.ownerId = p.ownerId
and a.fsl_tablecode = p.ownerType
and a.attrId = p.projectStatus
and a.attrTypeId = 2

where p.ownerId = 457
and p.projectDate >= '2015-01-01 00:00:00.000'

select p.projectTitle, d.description as sampleDetails, p.* from tbl_RD_Projects p
inner join tbl_RD_Samples s
on s.projectId = p.projectId
inner join tbl_RD_SampleDetails d
on d.sampleId = s.sampleId
where p.ownerId = 457
and p.projectDate >= '2015-01-01 00:00:00.000'

select p.projectTitle, s.* from tbl_RD_Projects p
inner join tbl_RD_Updates s
on s.projectId = p.projectId
where p.ownerId = 457
and p.projectDate >= '2015-01-01 00:00:00.000'