>Try

SELECT Video.Title,School.Title FROM Video;
>	LEFT JOIN Member ON Video.NoMember=Member.Numero;
>	LEFT JOIN School ON Member.NoSchool=Scool.Numero ;
>	WHERE Video.Type IN (1,2) ;
>UNION ;
>SELECT Video.Title,School.Title FROM Video;
>	LEFT JOIN Member ON Video.NoMember=Member.Numero;
>	LEFT JOIN School ON Member.NoSchool2=Scool.Numero ;
>	WHERE Video.Type =3
>

Thanks, this is what I was looking for. Fabio's suggestion is also another solution that works well as well.