SELECT *, (select vcity_name from city where city.ncityid = university_info.city) ct, (select vstate_name from state where state.nstateid = university_info.state) st from university_info where keyword = 'switcher' 0