用ado执行如下语句,出现2条相同的重复记录
INSERT INTO [tableName] SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,B1,B2,B3,B4,WP FROM [tableName2] IN 'E:\DISK.MDB' WHERE F1='7809600009'
谁知道如何解决
...全文
20410打赏收藏
用ado执行如下语句,出现2条相同的重复记录(很有难度哦)
用ado执行如下语句,出现2条相同的重复记录 INSERT INTO [tableName] SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,B1,B2,B3,B4,WP FROM [tableName2] IN 'E:\DISK.MDB' WHERE F1='7809600009' 谁知道如何解决
INSERT INTO [tableName] SELECT DISTINCT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,B1,B2,B3,B4,WP FROM [tableName2] IN 'E:\DISK.MDB' WHERE F1='7809600009'
INSERT INTO [tableName] SELECT DISTINCT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,F18,F19,F20,F21,F22,F23,B1,B2,B3,B4,WP FROM [tableName2] IN 'E:\DISK.MDB' WHERE F1='7809600009'