1
SELECT code FROM (
SELECT '210A' as codeUNION
SELECT '2117' as code
UNION
SELECT '2126' as code
UNION
SELECT '2131' as code
) a WHERE code NOT IN
(
SELECT code from ke_hu WHERE code IN
('210A',
'2117',
'2126',
'2131')
);
2
CREATE TEMPORARY TABLE temp_table3 (code varchar(32));
INSERT INTO temp_table3 VALUES ('210A');
INSERT INTO temp_table3 VALUES ('2117');
INSERT INTO temp_table3 VALUES ('2126');
INSERT INTO temp_table3 VALUES ('2131');
SELECT CODE FROM temp_table3
WHERE code NOT IN (
SELECT code from ke_hu WHERE code IN
('210A',
'2117',
'2126',
'2131')
);