On Thu, 30 Jan 2025, Rich Shepard wrote:
> Thanks again, David. I didn't know that's the section I need.
David/Ron, et al.:
Got it (example on page 2126 of the doc):
-- Display person_nbr, lname, fname, direct_phone, email from people, contact history from contacts.
-- prompt for person_nbr before selecting rows:
\prompt 'Enter person_nbr: ' who
select p.person_nbr, p.lname, p.fname, p.direct_phone, p.email, c.contact_date, c.contact_time, c.contact_type,
c.notes
from people as p natural inner join contacts as c
where p.person_nbr = (:'who')
order by c.contact_date, c.contact_time;
This works.
Thank you,
Rich