On Thu, Jun 21, 2018 at 12:22 PM, Ken Dibble <krdibble(a)stny.rr.com> wrote:
>
> Thank you, but I think I left out a requirement. The hours have to come from
> the most recent Hours records as well.
>
I should have realized that from your example solution. I *ASSuMEd* we
were totalling hours. My bad.
SELECT Consumer.*, Status.*, Hours.AppHours
FROM Consumer
JOIN Status on Consumer.ConPK=Status.ConFK
JOIN Hours on Consumer.ConPK=Hours.ConFK
WHERE Status.Date =
(SELECT MAX(Stat2.Date) FROM Status Stat2 WHERE
Stat2.ConFK = Consumer.ConPK GROUP BY Stat2.ConFK)
AND Status.Type = "Approved"
AND Hours.Date = Status.Date