SELECT * FROM wz WHERE CONCAT(wint,wchar) NOT IN (SELECT CONCAT(wint,wchar) FROM wa);

 SELECT * FROM wz WHERE CONCAT(wint,wchar)     IN (SELECT CONCAT(wint,wchar) FROM wa);

 TRUNCATE wz;

 INSERT INTO wz SELECT * FROM wa WHERE id>14;

 INSERT INTO wz SELECT * FROM wb WHERE id<9;

 INSERT INTO wz SELECT * FROM we WHERE id>10 AND id<15;

 UPDATE wz SET wchar=CONCAT(wint,'wz');

 INSERT INTO wz(wint,wchar) SELECT wint,wchar FROM wa WHERE id>14;

 INSERT INTO wz(wint,wchar) SELECT wint,wchar FROM wb WHERE id<9;

 INSERT INTO wz(wint,wchar) SELECT wint,wchar FROM we WHERE id>10 AND id<15;

 UPDATE wa SET wint=id+100;

 UPDATE wa SET wint=id+4444,wchar=CONCAT(wint,'wa');

 DELETE FROM wa WHERE id>16;

 UPDATE wb SET wint=id+1000;

 UPDATE wb SET wchar=CONCAT(wint,'wb');

 DELETE FROM wb WHERE id>16;

 UPDATE we SET wint=id+10000;

 UPDATE we SET wchar=CONCAT(wint,'we');

 DELETE FROM we WHERE id>16;