>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.