Where am I wrong with this sql statement?

gatuzo

Load the statistics into the temporary table tmptab, and then select the unique records to insert into the table tongji

insert into tongji
select * from tmptab
where cardnum, xfdate, xftime
not in (select cardnum, xfdate, xftime from tongji);

wzchuan

not in cannot use multiple fields
You can choose a unique key as the not in condition

unkmass

insert into tongji select tmptab. * from tmptab left outer join tongji on tmptab.cardnum = tongji.cardnum and tmptab.xfdate = tmptab.xfdate and tmptab.xftime = tongji.xftime where tongji.cardnum is not null
It's roughly like this, try it.

unkmass

The last condition is wrong, amended as follows:
insert into tongji select tmptab. * from tmptab left outer join tongji on tmptab.cardnum = tongji.cardnum and tmptab.xfdate = tmptab.xfdate and tmptab.xftime = tongji.xftime where tongji.cardnum is null