so the tbl_Data table has multiple "last modified" rows per ORGID?
from vw_ORG as o
join tbl_Data as d
on d.ORGID = o.ORGID
and d.LASTMODIFIED =
( select max(LASTMODIFIED)
where ORGID = o.ORGID )
join vw_Staff as s
on s.STAFFID = d.LASTMODIFIEDBY
Yes, that is corrrect.. I was able to get the quasi results needed by using SELECT DISTINCT?
But another issue is that I need to retireve all ORGS weather or not the have a last modified date or not. Is there a IS NULL function or something that can be used to with the select max(LASTMODIFIED) to do this?