#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 350103170081','B1 TRU07.54.023','A1 490033 ER','A3 TRU 07.54.023','A3 VAC V10-6289','C9 AC969','C4 2160186','A3 VAL 850850','A3 ERA 490033','B1 FEB103771','A9 VWL0325263','C4 850850V','C9 01.7441','C4 WAD102-L','A9 850850','B1 KAM7200019','C4 01.7441','C4 103771F','C9 50-0429','B1 VAI10-6289','B1 VNW0325263','A2 VWL0325263','A3 MAR 350103969000','B1 SKV01SKV393','B1 KAM7200197','A7 WAD102-L','C6 017016','B1 ELCZR AD711 L','A2 850850','A8 180 076','B1 MMAACQ0081','B1 VAL850850')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null))
#