select college.name, department.name, itstuff.name, ip.address
from college
left join department on college.id    = department.college
left join itstuff    on department.id = itstuff.department
left join ip         on itstuff.id    = ip.itstuff