#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 ('A2 8EA737479-001','C9 0001108220','B1 BOS0001108220','A2 458211','C9 0001108221','A1 0001108174','A9 458211','A1 WST380','A1 458211','A1 DRS8340','A3 VAL 458211','A2 0001108220','C9 0001108175','A1 458211/GR','A1 458211/GRX','A1 8EA 737 479-001','A3 HEL 8EA 737 479-001','A3 BOS 0001108220','A1 0001108220','A3 DEL DRS8340','A2 ERA 220476A','A8 542 051','B1 ASPS0408','C9 ELS25-2265','C9 S0408')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#