Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prvWk-0005mK-8p for pgsql-novice@arkaria.postgresql.org; Thu, 27 Apr 2023 06:54:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prvWg-000455-5g for pgsql-novice@arkaria.postgresql.org; Thu, 27 Apr 2023 06:54:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prKpT-0001Fk-MM for pgsql-novice@lists.postgresql.org; Tue, 25 Apr 2023 15:43:43 +0000 Received: from mail-vk1-xa42.google.com ([2607:f8b0:4864:20::a42]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1prKpR-0050nZ-M9 for pgsql-novice@lists.postgresql.org; Tue, 25 Apr 2023 15:43:43 +0000 Received: by mail-vk1-xa42.google.com with SMTP id 71dfb90a1353d-44058ece4f3so3663031e0c.1 for ; Tue, 25 Apr 2023 08:43:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1682437420; x=1685029420; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=4ypeQXMSx4LrsIxh5/F7XYn296wfCBjnKxUWA12IF78=; b=SOPuX6d2rydIlUhGHT+0mLOlQ8CDSn3hpbeIlqK7H+oeBm8BId4S9nCkcn/D42YilA dn+ReqP8Ak3TeFnhmUHub7VZGBzqfhf2aF7UWDBZdxroKpzx3fM/NtagCSXnMQNwFNxD JgHfEwzu882FZYlhQ1SKZW063ozw4iHK4/xwFS5skzv/Z3jbC01hU2/0FZJLtewitWce sFAbi0DjzlAAjJPi+A+tXt1M0D9WESggaeAP8Q0CSiCNWcZRNeFUSjaaPPTFnfuYBD7x vhBRFkNrUo3hTOV3nW0S/RRs1VDSvWJ6g1R3PI8uBLzcPVYc75shZc+/87wSXxUKtiOD CEow== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682437420; x=1685029420; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=4ypeQXMSx4LrsIxh5/F7XYn296wfCBjnKxUWA12IF78=; b=b+FUp7g52y2jn5R1teQiXacrePC1vRsYE7a/CP8rypxefZNuLYGiTuy8I2UnRgHr/s gqd7z9BDprZbvUYUaHo2P6/Y18IqZCUMCgawgBG1feIDwUApRl13IC+hMhdp88mQi2eX 9+W9EYl8LT1ZR9QPoy/fhE+rw7APNmNUgAm/n46FuTyKrpsL92IP1dqDesy0ah4xVBov SGqMCF5e8mK+erT+NFJGHpmItH37aA14oxdBBJIjf/VjYgDKczUk3DezwpTg/BgIWhWU xaCQQR0HEYkLrc8z609GXEZIe4qjRq4ORVJ2NZpE9GgBEWUIioAMtsY4TomfI52DmO9B ua4A== X-Gm-Message-State: AAQBX9dix+bgtAyBg1iO+7Xupc6Nxc/SfRxxyH0ctnit2bgaB0Bonmj8 QcB7g+X3dP63QTaQiyJF2R5djcmdtDnApQg3H7nc3u2YCgOG6IWO X-Google-Smtp-Source: AKy350Y3V8a3zLFZXF0g+PPSiPZdP9D5Vp/g+4YS50iFhIDt2cCqjKB1baUjOWuxnNwt58dGpfTuAP+WwdrhjZGOoH8= X-Received: by 2002:a1f:5cca:0:b0:43f:ec5d:51e1 with SMTP id q193-20020a1f5cca000000b0043fec5d51e1mr6126023vkb.9.1682437420036; Tue, 25 Apr 2023 08:43:40 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a59:d9c3:0:b0:3b7:9e72:98a1 with HTTP; Tue, 25 Apr 2023 08:43:39 -0700 (PDT) From: e-letter Date: Tue, 25 Apr 2023 16:43:39 +0100 Message-ID: Subject: insert into table with nest query To: pgsql-novice@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Readers, table1 column1,column2 value1,value2 table2 column2,column3 value2, value3 table3 column1,column2,column3 value1,value2,value3 When value3 is first entered into table2, what are the correct commands for value2 (in table2) and value1 (in table1) to be selected for insertion into table 3? INSERT INTO table3 SELECT ... WHERE value3='...'; The conceptual difficulty is how to use nested query correctly, or is there a better method? Thank you.