SELECT		Res.rID, Res.rDate, Res.rName, Res.rTotalPass AS Total,
		SUM(CASE WHEN Special.sAdult = 1 THEN Res2.r2Pass ELSE 0 END) AS Ad,
		SUM(CASE WHEN Special.sChild = 1 THEN Res2.r2Pass ELSE 0 END) AS Child,
		SUM(CASE WHEN Special.sInfant = 1 THEN Res2.r2Pass ELSE 0 END) AS Inf 
FROM		Reservations AS Res
INNER JOIN	Res2 ON Res2.rID = Res.rID
LEFT JOIN	Special ON Special.sID = Res2.sID

rID 	|	rDate		|	 rName		|	Total	|	 Ad 	|	Child 	|	Inf
387	|	01/01/06	|	Harrison	|	3	|	3	|	0	|	0
418	|	01/01/06	|	Childs		|	5	|	0	|	2	|	0
418	|	01/01/06	|	Childs		|	5	|	3	|	0	|	0

rID 	|	rDate		|	 rName		|	Total	|	 Ad 	|	Child 	|	Inf
387	|	01/01/06	|	Harrison	|	3	|	3	|	0	|	0
418	|	01/01/06	|	Childs		|	5