public inbox for [email protected]  

help / color / mirror / Atom feed

From: swastik Gurung <[email protected]>
To: [email protected] <[email protected]>
To: Ibrahim Shaame <[email protected]>
Subject: Re: Reporting by family tree
Date: Thu, 5 Oct 2023 13:15:07 +0000 (UTC)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com>
References: <CAJOWwD5M=YK9nKBX6TD-NB1B7Ddo6uLZC2fG1WAED86fg4s2oA@mail.gmail.com>

 I suppose you ought to be using, recursive CTE queries
Documentation can be found at: 7.8. WITH Queries (Common Table Expressions)

| 
| 
| 
|  |  |

 |

 |
| 
|  | 
7.8. WITH Queries (Common Table Expressions)

7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Tabl...
 |

 |

 |




    On Thursday, 5 October 2023 at 16:44:46 GMT+5:45, Ibrahim Shaame <[email protected]> wrote:  
 
   
I have a table of members of alarge family extendending back to eight generations. The currentmembers contribute a monthly amount to the family fund. Only truedescendants 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





NowI want to report Names and contributions par family tree: My ideal isto list grandfather, father, children based on the two fields (id,parentid). 


Any suggestions? 


Thanks in advance



  

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]
  Subject: Re: Reporting by family tree
  In-Reply-To: <[email protected]>

* 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