Code: Select all
INSERT INTO CAP_ISTAT_OK ( COMUNE, PR, IDREG, REG, CAP, PROVINCIA, CF, REGIONE )
SELECT CAP_ISTAT.COMUNE, CAP_ISTAT.PR, CAP_ISTAT.IDREG, CAP_ISTAT.REG, CAP_ISTAT.CAP, CAP_ISTAT.PROVINCIA, CAP_ISTAT.CF, CAP_ISTAT.REGIONE
FROM CAP_ISTAT