From: | Ibrahim Shaame <ishaame(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Reporting by family tree |
Date: | 2023-10-05 10:58:55 |
Message-ID: | CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have a table of members of a large family extendending back to eight
generations. The current members contribute a monthly amount to the family
fund. Only true descendants are included in the family list, no wives, no
husbands. There are two tables
1 - Names with the following fields: idno (unique) --family member
parentid -- id number of the parent who connected the child to the family
etc
etc
2 – Contributions with fields: idno
etc
etc
Now I want to report Names and contributions par family tree: My ideal is
to list grandfather, father, children based on the two fields (id,
parentid).
Any suggestions?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | swastik Gurung | 2023-10-05 13:15:07 | Re: Reporting by family tree |
Previous Message | Devrim Gündüz | 2023-09-22 15:13:48 | Re: Issue with yum repository - python3-barman-3.7.0-1PGDG.rhel7.noarch.rpm has no gpg signature |