#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 017116','A2 MET 0916009','C4 0916009','C9 B18002','C6 105069','C9 50-0135','B1 SKV96SKV100','B7 0916009/MTZ','C6 017370','C4 114742HP','B1 VKA99411772701','B1 TRU07.42.073','A3 ERA 662415','A3 TRU 07.42.073','A2 30 93 7783','A9 30 93 7783','C4 23628MD','B1 VEM10-73-0132','A5 59497','A8 518 551','B1 HP108 893','C4 108893HP','C9 HP108 893','E2 108 893 755')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#