#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 ('C6 017811','A3 MHL ASE21000P','C4 DPS32005','C9 NIS301101','A5 147604','A1 ASE 21 000P','B7 38949/NRF','B1 DENDPS32005','A5 233620','B1 VEM10-73-0300','C4 114 899 0015MY','C4 38949NRF','C4 07.59.082','C9 21-0379','B1 NIS301101','A3 DEN DPS32005','A8 557 607','A8 629 165','B1 TRU07.59.082','B1 BETASE 21 000P','C9 NRF38949','C4 K52088MD','C4 0917270','A2 ERA 330868','C4 ASE 21 000P','C9 ASE21000P','C4 V10-73-0300','B1 NRF38949')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#