Query : Insert Tabel dari Tabel Lain MYSQL

Contoh :

insert into absenkaryawan(userid,nik,nama,checkin,checkout,serijadwal,tanggal,periode,machinenumber) select userid,nik,nama,min(checktime),max(checktime),serijadwal,DATE_FORMAT(checktime,'%Y-%m-%d'),substr(serijadwal,1,6),machinenumber from checkinout where STATUSUPLOAD!='OK' group by nik,serijadwal