#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 ('C9 WR008','C4 01.3918','B1 MMAAC552','A3 MAR 350103552000','A3 ERA 490030','C4 850597V','C9 1009090010','C9 VAL850597','A1 01.3918 AC','A2 850597','B1 VAL850597','A8 150 814','C9 AC552','A3 VAL 850597','A1 1244 736','C4 2160055','A9 850597','C9 111276755','E2 111 276 755','A1 350103552000','A1 490030 ER','A3 TRU 07.53.063','A1 850597','C9 01.3918','A8 152 871','B1 FEB175445','B1 KAM7200196','C6 102115')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#