Garrett Murphy wrote:
Jeff:
I may not fully understand the situation or the data you're trying to retrieve, but if
you're trying to get show me all trainers whose current status is Pending, I
would go backwards to how you're doing it. If you're only concerned about those records
with
I'm stumped about the best was to retrieve the most recent entry in a
one-to-many type of table and combine it with a more standard query
that joins one-to-one.
I have defined these:
jr...@wykids localhost# \d trainer_dates
Table public.trainer_dates
Jeff:
I may not fully understand the situation or the data you're trying to retrieve,
but if you're trying to get show me all trainers whose current status is
Pending, I would go backwards to how you're doing it. If you're only
concerned about those records with tr_date_name = Pending, then