On Thursday, August 19, 2021, Rich Shepard <
rshepard@appl-ecosys.com> wrote:
On Thu, 19 Aug 2021, Adrian Klaver wrote:
So take David Johnston's query:
Select distinct on (person_nbr) ….. order by person_nbr, contact_date desc;
Adrian,
contact_date --------------
2021-08-17
What’s your point?
Select distinct on (person_nbr) * from contacts where next_contact <= current_date order by person_nbr, contact_date desc;
Select distinct on (p.person_nbr) * from c.contacts
from people as p, contacts as c
where cnext_contact <= current_date and
p.person_nbr = c.person_nbr
order by p.person_nbr, c.contact_date desc;
$ psql -d bustrac -f test_query.sql
psql:test_query.sql:5: ERROR: syntax error at or near "from"
LINE 2: from people as p, contacts as c
^
Yeah, you wrote two from clauses…
David J.