[GENERAL] How to INSERT INTO one table from another table, WHERE

[Kirk Wythers]

I am trying to insert data from 2 columns in tableB (colX and colY) into the 
same two columns of tableB, with a join like where clause. Is this possible? 

For example:

INSERT INTO tableA (colX, colY) 
(SELECT colX, colY
FROM tableB
WHERE
        tableA.blockname = tableB.block_name
        AND tableA.timestamp = tableB.timestamp)
;




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general