Cacher is the code snippet organizer for pro developers

-----SELECT PER I CONTATORI DEL RAPPORTINO---
SELECT AR64.AR64_IDSEQ_AR31 IdImpianto, AR65.*
FROM AR61_RAPPTESTA AR61 													-- TESTATA RAPPORTINO
	LEFT OUTER JOIN AR63_RAPPARTICOLI AR63 									--RIGHE MATERIALI
		ON AR61.AR61_NUMREG_CO99 = AR63.AR63_NUMREG_CO99
			LEFT OUTER JOIN AR64_RAPPRIGHE AR64 							--RIGHE RAPPORTINO
				ON AR63.AR63_NUMREG_CO99 = AR64.AR64_NUMREG_CO99
					LEFT OUTER JOIN AR65_RAPPCONT AR65 						--TAB CONTATORI
						ON AR64.AR64_NUMREG_CO99 = AR65.AR65_NUMREG_CO99
WHERE AR61.AR61_NUMINT = N'10029'; 											--NUMERO INTERVENTO RAPPORTINO