drop table if exists t1, t2;

CREATE TABLE `t1` (
  `f1` int(10) unsigned NOT NULL auto_increment,
  `f2` int(10) unsigned NOT NULL default '0',
  `f3` decimal(7,2) unsigned NOT NULL default '0.00',
  `f4` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`f1`),
  KEY `k1` (`f2`)
) ENGINE=MEMORY AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `t2` (
  `f1` varchar(10) NOT NULL default '',
  `f2` char(3) NOT NULL default '',
  `f3` char(3) NOT NULL default '',
  PRIMARY KEY  (`f1`),
  KEY `k1` (`f2`,`f3`,`f1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO t1 (f2,f3) values('298', '1639.00');

INSERT INTO `t2` VALUES ('474404','WDT','YYJ'),('474436','WDT','YYJ'),('474468','WDT','YYJ'),('474500','WDT','YYJ'),('474532','WDT','YYJ'),('474564','WDT','YYJ'),('474596','WDT','YYJ'),('474628','WDT','YYJ'),('474660','WDT','YYJ'),('474692','WDT','YYJ'),('474782','WDT','YYJ'),('474814','WDT','YYJ'),('474846','WDT','YYJ'),('474886','WDT','YYJ'),('475130','WDT','YYJ'),('485973','WDT','YYJ'),('486285','WDT','YYJ'),('486446','WDT','YYJ'),('486544','WDT','YYJ'),('486812','WDT','YYJ'),('486844','WDT','YYJ'),('486876','WDT','YYJ'),('486908','WDT','YYJ'),('358325','WDT','YYT'),('358327','WDT','YYT'),('358328','WDT','YYT'),('358333','WDT','YYT'),('358334','WDT','YYT'),('358340','WDT','YYT'),('358346','WDT','YYT'),('358347','WDT','YYT'),('358358','WDT','YYT'),('358361','WDT','YYT'),('358366','WDT','YYT'),('358370','WDT','YYT'),('358372','WDT','YYT'),('358373','WDT','YYT'),('358375','WDT','YYT'),('358376','WDT','YYT'),('358380','WDT','YYT'),('358381','WDT','YYT'),('358386','WDT','YYT'),('358387','WDT','YYT'),('358391','WDT','YYT'),('358392','WDT','YYT'),('358394','WDT','YYT'),('358398','WDT','YYT'),('358401','WDT','YYT'),('358403','WDT','YYT'),('358404','WDT','YYT'),('358405','WDT','YYT'),('358408','WDT','YYT'),('358409','WDT','YYT'),('358410','WDT','YYT'),('358412','WDT','YYT'),('358413','WDT','YYT'),('358414','WDT','YYT'),('358415','WDT','YYT'),('358417','WDT','YYT'),('358418','WDT','YYT'),('399155','WDT','YYT'),('463595','WDT','YYT'),('464375','WDT','YYT'),('468404','WDT','YYT'),('474405','WDT','YYT'),('474437','WDT','YYT'),('474469','WDT','YYT'),('474501','WDT','YYT'),('474533','WDT','YYT'),('474565','WDT','YYT'),('474597','WDT','YYT'),('474629','WDT','YYT'),('474661','WDT','YYT'),('474693','WDT','YYT'),('474783','WDT','YYT'),('474815','WDT','YYT'),('474847','WDT','YYT'),('474887','WDT','YYT'),('475131','WDT','YYT'),('485974','WDT','YYT'),('486286','WDT','YYT'),('486447','WDT','YYT'),('486545','WDT','YYT'),('486813','WDT','YYT'),('486845','WDT','YYT'),('486877','WDT','YYT'),('486909','WDT','YYT'),('357905','WDT','YYZ'),('357907','WDT','YYZ'),('357908','WDT','YYZ'),('357913','WDT','YYZ'),('357914','WDT','YYZ'),('357920','WDT','YYZ'),('357926','WDT','YYZ'),('357927','WDT','YYZ'),('357938','WDT','YYZ'),('357941','WDT','YYZ'),('357946','WDT','YYZ'),('357950','WDT','YYZ'),('357952','WDT','YYZ'),('357953','WDT','YYZ'),('357955','WDT','YYZ'),('357956','WDT','YYZ'),('357960','WDT','YYZ'),('357961','WDT','YYZ'),('357966','WDT','YYZ'),('357967','WDT','YYZ'),('357971','WDT','YYZ'),('357972','WDT','YYZ'),('357974','WDT','YYZ'),('357978','WDT','YYZ'),('357981','WDT','YYZ'),('357983','WDT','YYZ'),('357984','WDT','YYZ'),('357985','WDT','YYZ'),('357988','WDT','YYZ'),('357989','WDT','YYZ'),('357990','WDT','YYZ'),('357992','WDT','YYZ'),('357993','WDT','YYZ'),('357994','WDT','YYZ'),('357995','WDT','YYZ'),('357997','WDT','YYZ'),('357998','WDT','YYZ'),('399156','WDT','YYZ'),('463596','WDT','YYZ'),('464376','WDT','YYZ'),('468405','WDT','YYZ'),('474406','WDT','YYZ'),('474438','WDT','YYZ'),('474470','WDT','YYZ'),('474502','WDT','YYZ'),('474534','WDT','YYZ'),('474566','WDT','YYZ'),('474598','WDT','YYZ'),('474630','WDT','YYZ'),('474662','WDT','YYZ'),('474694','WDT','YYZ'),('474784','WDT','YYZ'),('474816','WDT','YYZ'),('474848','WDT','YYZ'),('474888','WDT','YYZ'),('475132','WDT','YYZ'),('485975','WDT','YYZ'),('486287','WDT','YYZ'),('486448','WDT','YYZ'),('486546','WDT','YYZ'),('486814','WDT','YYZ'),('486846','WDT','YYZ'),('486878','WDT','YYZ'),('486910','WDT','YYZ');

select count(*) from t1;

INSERT INTO t1 (f4)
( SELECT group_concat(pf.f1) as f4_not FROM t1 as ot join t2 as pf on ( pf.f2 = 'SIR' and pf.f3 = 'SIR') WHERE ot.f2=298 GROUP BY ot.f1);

select count(*) from t1;