Re: Refining query statement

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Refining query statement
Date: 2019-01-18 00:07:19
Message-ID: CAKFQuwZ+hMNOrmQq2=pauj3P1v1YX29OEM_pvC0CUK5eX3pe6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 17, 2019 at 3:44 PM Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
> FROM People AS p
> JOIN Organizations AS o ON p.org_id = o.org_id
> JOIN Contacts AS c ON c.person_id = p.person_id

I would advise changing Contacts to "Activities" as the former can
readily be interpreted (and is in the wild) as both "an instance of
contacting a person" and "the person at the organization who is being
contacted" (i.e., your People class).

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-01-18 00:24:05 Re: Refining query statement
Previous Message Rich Shepard 2019-01-18 00:04:45 Re: Refining query statement