select u.*,up.Address,up.ZIPCode ,up.EnglishAddress
from CF_University u 
inner join CF_UniversityProfile up on u.UniversityID=up.UniversityID;