不插入得复的字段值,如何写

Question

insert test_2(date,time,card_number)
  select date,time,card_number from test_1
where not exists(select * from test_2 
    where test_1.date = test_2.date and test_1.time = test_2.time and test_1.card_number  = test_2.card_number)

Answer 1

insert into TEST_2([date],[time],card_number)
select 
    distinct [date],[time],card_number 
from 
    TEST_1 A 
where 
    not exists(select 
                   1 
               from 
                   TEST_2 
               where 
                   [date]=A.[date] 
                   and 
                   [time]=A.[time] 
                   and 
                   card_number=A.card_number)