Eric, thanks but I already said I've tried that approach. If only it were that simple. Anyone else?

>

>SELECT ListOrder.ListID, List.Listname, Count.Updated
>	FROM ListOrder
>	LEFT OUTER JOIN Count ON
>	ListOrder.ListID=Count.ListID AND ListOrder.SelectID=Count.SelectID
>	JOIN List ON
>	ListOrder.ListID=List.ListID
>	WHERE List.ManagerID = 1875
>        AND Count.Updated >= GetDate()-180
>	GROUP BY ListOrder.ListID, List.Listname, Count.Updated
>