Hehe, sounds tricky.
There's prossibly a more elegant solution, but this one may work, aliasing
the master table a few times with different names:
SELECT s.*, r1.name, r2.name, r3.name
FROM schedule s, ref_master r1, ref_master r2, ref_master r3
WHERE s.ref1_id=r1.id
AND s.ref2_id=r2.id
AND
I am retrieving values to form a shedule for referees. The master shedule
contains all info for a given date with three referees for that game. The
three referees are refrenced by their id number from the referee information
table. I am now stuck trying to figure out how to take the three refer
