public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Ibrahim Shaame <[email protected]>
Cc: swastik Gurung <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Reporting by family tree
Date: Mon, 16 Oct 2023 06:10:50 -0700
Message-ID: <CAKFQuwYn6MfTyjpDraVqW7TfnCh2Q3-DvfEYHz+vifXvzpr_FA@mail.gmail.com> (raw)
In-Reply-To: <CAJOWwD6ED658ZAg80YK85sFq=vObnrj6f086tNug6C8=K7wn3w@mail.gmail.com>
References: <CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com>
<[email protected]>
<CAJOWwD7YmD8jPediD7qG49vq9mtTbJOx3eAV4a9234RTJe_aHw@mail.gmail.com>
<CAKFQuwaMRJUpMz8Usd3XHfymgdR=51G-CjOpi16nxWh+kytD0Q@mail.gmail.com>
<CAJOWwD6ED658ZAg80YK85sFq=vObnrj6f086tNug6C8=K7wn3w@mail.gmail.com>
On Monday, October 16, 2023, Ibrahim Shaame <[email protected]> wrote:
> Thanks David for the reply. But I think you missed part of the code, which
> refers to ukoo:
> )
>
> SELECT g.jina AS jina_la_mtoto,
> g.baba AS baba_wa_mtoto,
> g.babu AS babu_wa_mtoto,
> g.namba,
> mzazi.jina AS jina_la_mzazi,
> mzazi.baba AS jina_la_baba_la_mzazi,
> g.daraja
> FROM ukoo g
> JOIN majina2 mzazi
> ON g.namba = mzazi.namba
> ORDER BY g.namba;
>
> Any suggestion?
>
That part of the query is outside the CTE and thus doesn’t impact the CTE’s
results. The part of the query that needs to be self-referencing is the
subquery inside the CTE under the Union All.
David J.
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Reporting by family tree
In-Reply-To: <CAKFQuwYn6MfTyjpDraVqW7TfnCh2Q3-DvfEYHz+vifXvzpr_FA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox