#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 ('A1 7.21765.50','C9 VAL256569','A5 298309','A8 514 213','A1 256569','A2 256569','A2 7.21765.50.0','C9 1009050000','A3 VAL 256569','C4 V15-80-3217','C9 7.21765.50.0','B1 PIE7.21765.50.0','C4 256569V','C4 100 905 0000MY','A3 PIE 7.21765.50.0','B1 VEM15-80-3217','B1 VAL256569','A1 70513146HB','A8 556 406','B1 HP103 768','C4 103768HP')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#