On Thursday, August 19, 2021, Rich Shepard <rshep...@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.
