MIME-Version: 1.0
In-Reply-To: 
 <CAJOWwD6ED658ZAg80YK85sFq=vObnrj6f086tNug6C8=K7wn3w@mail.gmail.com>
References: 
 <CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com>
 <1901532185.8873313.1696511707263@mail.yahoo.com>
 <CAJOWwD7YmD8jPediD7qG49vq9mtTbJOx3eAV4a9234RTJe_aHw@mail.gmail.com>
 <CAKFQuwaMRJUpMz8Usd3XHfymgdR=51G-CjOpi16nxWh+kytD0Q@mail.gmail.com>
 <CAJOWwD6ED658ZAg80YK85sFq=vObnrj6f086tNug6C8=K7wn3w@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 16 Oct 2023 06:10:50 -0700
Message-ID: 
 <CAKFQuwYn6MfTyjpDraVqW7TfnCh2Q3-DvfEYHz+vifXvzpr_FA@mail.gmail.com>
Subject: Re: Reporting by family tree
To: Ibrahim Shaame <ishaame@gmail.com>
Cc: swastik Gurung <gurung_swastik@yahoo.com>,
	"pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a6a5890607d522d9"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwYn6MfTyjpDraVqW7TfnCh2Q3-DvfEYHz%2BvifXvzpr_FA%40mail.gmail.com>
Precedence: bulk

--000000000000a6a5890607d522d9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, October 16, 2023, Ibrahim Shaame <ishaame@gmail.com> wrote:

> Thanks David for the reply. But I think you missed part of the code, whic=
h
> 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 =3D mzazi.namba
> ORDER BY g.namba;
>
> Any suggestion?
>

That part of the query is outside the CTE and thus doesn=E2=80=99t impact t=
he CTE=E2=80=99s
results.  The part of the query that needs to be self-referencing is the
subquery inside the CTE under the Union All.

David J.

--000000000000a6a5890607d522d9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Monday, October 16, 2023, Ibrahim Shaame &lt;<a href=3D"mailto:ishaame@g=
mail.com">ishaame@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
"><div dir=3D"ltr"><div>Thanks David for the reply. But I think you missed =
part of the code, which refers to ukoo:</div><div>)<br>=C2=A0<br>SELECT =C2=
=A0g.jina AS jina_la_mtoto,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 g.baba AS baba_w=
a_mtoto,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 g.babu AS babu_wa_mtoto,<br>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 g.namba,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 mzazi.jina AS =
jina_la_mzazi,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 mzazi.baba AS jina_la_baba_la=
_mzazi,<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 g.daraja<br>FROM ukoo g<br>JOIN maji=
na2 mzazi<br>ON g.namba =3D mzazi.namba<br>ORDER BY g.namba;</div><div><br>=
</div><div>Any suggestion?</div></div></blockquote><div><br></div><div>That=
 part of the query is outside the CTE and thus doesn=E2=80=99t impact the C=
TE=E2=80=99s results.=C2=A0 The part of the query that needs to be self-ref=
erencing is the subquery inside the CTE under the Union All.</div><div><br>=
</div><div>David J.</div><div>=C2=A0</div>

--000000000000a6a5890607d522d9--