Select  distinct  * from tmp_Worklist where lastupdateddatetime > (DATEADD(hh, -6, GetDAte())) order by fokey desc
select * from Exam where ExamKey in (Select distinct exkey from tmp_Worklist where lastupdateddatetime > (DATEADD(hh, -6, GetDAte()))) order by FillerOrderKey desc
select * from FillerOrder where AccessionNumber in (Select distinct accessionnumber from tmp_Worklist where lastupdateddatetime > (DATEADD(hh, -6, GetDAte()))) order by FillerOrderKey desc
select * from ExamFlat where AccessionNumber in (Select distinct accessionnumber from tmp_Worklist where lastupdateddatetime > (DATEADD(hh, -6, GetDAte()))) order by FillerOrderKey desc
select * from ExamWorkflow where FillerOrderKey in (Select distinct fokey from tmp_Worklist where lastupdateddatetime > (DATEADD(hh, -6, GetDAte()))) order by FillerOrderKey desc
select * from CaseNotes where CaseNotesKey in (select CaseNotesKey from ExamWorkflow where FillerOrderKey in (Select distinct fokey from tmp_Worklist where lastupdateddatetime > (DATEADD(hh, -6, GetDAte())))) order by FillerOrderKey desc