, 19 2017 . 14:13
+
!
, , :
, Base Import.
: Base Import, , Base
:
INSERT INTO Base({.. ..})
SELECT ({.. ..}) FROM Import WHERE NOT EXISTS(
SELECT ({.. ..}) FROM Base WHERE Base.field1=Import.field1 And Base.field2=Import.field2 And ... And Base.fieldn=Import.fieldn
))
:
SELECT (Count(*)) FROM Import WHERE NOT EXISTS(
SELECT ({.. ..}) FROM Base WHERE Base.field1=Import.field1 And Base.field2=Import.field2 And ... And Base.fieldn=Import.fieldn
))
, , Count. , Import. Import, Base Import? , INSER INTO ... SELECT , .
, , :
INSERT INTO ... SELECT
?
http://www.sql.ru/forum/1274552/insert-into-select
