select `year`,`dnum` from `spt_hk649` where `year` in ('107','106') and `dnum` in ('107016','107015','107014','107013','107012','107011','107010','107009','107008','107007','107006','107005','107004','107003','107002','107001','106153','106152','106151','106150') select `year`,`dnum` from `spt_tw638` where `year` in ('107') and `dnum` in ('107015','107014','107013','107012','107011','107010','107009','107008','107007','107006') select `year`,`dnum` from `spt_tw649` where `year` in ('107') and `dnum` in ('107018','107017','107016','107015','107014','107013','107012','107011','107010','107009') select `year`,`dnum` from `spt_tw539` where `year` in ('107') and `dnum` in ('107043','107042','107041','107040','107039','107038','107037','107036','107035','107034') INSERT INTO `spt_tw539` VALUES ('','107','107043','107.02.19','38','13','25','07','33') Array ( [year] => Array ( [0] => 107 [1] => 107 [2] => 107 [3] => 107 [4] => 107 [5] => 107 [6] => 107 [7] => 107 [8] => 107 ) [dnum] => Array ( [0] => 107034 [1] => 107035 [2] => 107036 [3] => 107037 [4] => 107038 [5] => 107039 [6] => 107040 [7] => 107041 [8] => 107042 ) ) select `year`,`dnum` from `spt_tw740` where `year` in ('107') and `dnum` in ('107014','107013','107012','107011','107010','107009','107008','107007','107006','107005')