请教大侠们个SQL语句！

Question

insert into ATMASTER_BK
select a.* from ATMASTER a where 
      not exists (select 1 from ATMASTER_BK b
                             where 
                                   b.Card_ID_number = a.Card_ID_number 
                             and
                                   b.Date = a.Date
                             and
                                   b.Time_HHMM = a.Time_HHMM)

Answer 1

insert into ATMASTER_BK
select a.* from ATMASTER a where CardID
      not in (select CardID from ATMASTER_BK b
                             where 
                                   b.Card_ID_number = a.Card_ID_number 
                             and
                                   b.Date = a.Date
                             and
                                   b.Time_HHMM = a.Time_HHMM)