NOT IN statement

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

NOT IN statement

Post by sal21 »

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
i need to append into CAP_ISTAT_OK all from CAP_ISTAT, only if CF in CAP_ISTAT_OK are missing from ...

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: NOT IN statement

Post by HansV »

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
WHERE CAP_ISTAT.CF NOT IN (SELECT CAP_ISTAT_OK.CF FROM CAP_ISTAT_OK)
Best wishes,
Hans