>

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

Thanks, I got two different approaches to resolve this issue in this therad. I was not aware we could do that in the JOIN clauses.