I am trying to know if something is possible. I have a Member table which contains NoSchool and NoSchool2. Those two fields are relational fields of School.dbf. So, a member can be related to two schools. I also have a Video table which contains a relation to a member. So, Video.NoMember exists and can be empty.
The situation I am trying to resolve is to display a video list by showing the school title, if a relation exists. So, normally, if I would only have one field Member.NoSchool, I would be able to do something like this:
SELECT Video.Title,School.Title FROM Video;
LEFT JOIN Member ON Video.NoMember=Member.Numero;
LEFT JOIN School ON Member.NoSchool=School.Numero
But, in this case, the relation can come from either Member.NoSchool or Member.NoSchool2. I have a decision process to know which one to take. If Video.Type=1 or Video.Type=2, I will take Member.NoSchool. If Video.Type=3, I will take Member.NoSchool2. Is this possible?