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