Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qoM50-000yzT-I0 for pgsql-novice@arkaria.postgresql.org; Thu, 05 Oct 2023 10:59:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qoM4y-00CB2s-Bj for pgsql-novice@arkaria.postgresql.org; Thu, 05 Oct 2023 10:59:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qoM4y-00CB2Y-2n for pgsql-novice@lists.postgresql.org; Thu, 05 Oct 2023 10:59:41 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qoM4w-0008Te-Jl for pgsql-novice@lists.postgresql.org; Thu, 05 Oct 2023 10:59:39 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-99de884ad25so151049766b.3 for ; Thu, 05 Oct 2023 03:59:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696503576; x=1697108376; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=9RHaUbodwQJtYG3tK6us5a1j08X/mM6fDpiAmiCrKqw=; b=Am/XhPtSRm16LCN9eZWmcHLDySv4ocW9TcjYC9JKlcqaJjRBqXxuOHY5ILwBVh7quu 4Ie8nPqfrSxYa1lnABQMmAdS+JHtDmGAzS0zuldY+P6wVG1CwosH5tNyv1kAkOdVLNuK NcIfU2hKzgTsS/ojyAizwPc4RumWuarAV5u0pBogCEO1dW8VoGMVJCgPyhrpqNK6yAHZ Y7vAxlNgd/9qbGsu4zX7XbpSgYoOwECUHuywB0OykHjxh4RGbhrWV0Tf7owyv1D2LLwE cNUp4EGCb/VhyMOeK7EWv+pbCdsFdOq7mO04z4HROiir3TaTHfPIHLTMWvBU/jcTbcpJ eACQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696503576; x=1697108376; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=9RHaUbodwQJtYG3tK6us5a1j08X/mM6fDpiAmiCrKqw=; b=tGp3IKWyhg+cqSMQn8ZycAwAs9lzlUclOkNDZLJG4fQTHl7+ZD0KlXgFHxk6yLVtqM KbDO+eJAzCqIwYkpA04YUHTyyPVE6VkeNaFMeUl55voX5lmIBFKkOZ4RX+cnndjBrt1p DXyazNQ4dFKz9eh6agqSUFJ3TSHPUxojfe6x2QCg40Q1gkoJM99rC4iYdaByxe7ryOfC 4K5uJfw6pscrnMrurQ+Y3efgXGEYYCHHuoFj1OIsdyd89+kRb1fjSk3bhw0Cgd9n3TKp zUYZMRTAxr731qysB4iXjXI4gTOwJysj94cLZECeDvy6eVtLjbaTTtsE2hRDVrJiNOjT Dqag== X-Gm-Message-State: AOJu0YzILcYr+bTZovz0Zuq0Wy1WR1+ANYN+V1vjo3Z2gOguKKJMPHcL zmofEpOhaTeuHklkXVzAc+8eZfbIKNGgvgofgJitHFn4c5k= X-Google-Smtp-Source: AGHT+IGKSao0Fc8nEc7ExZK1SZfWCXkEhYYw8KDN5CfIjHpc3I3Ciup83G5mZEHkz14kFNfbAOzpw0mpM1iE8vSLTMA= X-Received: by 2002:a17:907:7702:b0:9ae:5523:3f84 with SMTP id kw2-20020a170907770200b009ae55233f84mr4104514ejc.72.1696503576105; Thu, 05 Oct 2023 03:59:36 -0700 (PDT) MIME-Version: 1.0 From: Ibrahim Shaame Date: Thu, 5 Oct 2023 13:58:55 +0300 Message-ID: Subject: Reporting by family tree To: pgsql-novice@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000000395de0606f6058c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000395de0606f6058c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 =E2=80=93 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 --0000000000000395de0606f6058c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
=09 =09 =09

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 =E2=80=93 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 suggest= ions?

Thanks in advanc= e


--0000000000000395de0606f6058c--