#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr
FROM cikk_tecdoc
LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam)
WHERE
((cikk_tecdoc.cikkszam IN ('A8 536 412','C9 FE43778','A3 ERA 550476','C4 43778F','A1 550476 ER','B1 FAE79292','A2 30 94 3778','C4 9.0514','C9 1-953-514','A1 79292 FA','C9 FAE79292','B1 EPS1.953.514','A8 522 220','A1 9.0514','B1 FEB43778','B1 HP114 216','A3 INT 19257','A2 ERA 550476A','B1 TRU07.17.117','C4 07.17.117','C9 24-0219')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#