select* from Users u innerjoin UserPhoneNumbers upn on u.user_id= upn.user_id innerjoin UserScreenNames usn on u.user_id= usn.user_id innerjoin UserAffiliations ua on u.user_id= ua.user_id innerjoin Affiliations a on a.affiliation_id = ua.affiliation_id innerjoin UserWorkHistory uwh on u.user_id= uwh.user_id innerjoin Affiliations wa on uwh.affiliation_id = wa.affiliation_id
下面,我们用一个视图来替换上面的查找过程:
CREATEVIEW `vusers` AS select* from Users u innerjoin UserPhoneNumbers upn on u.user_id= upn.user_id innerjoin UserScreenNames usn on u.user_id= usn.user_id innerjoin UserAffiliations ua on u.user_id= ua.user_id innerjoin Affiliations a on a.affiliation_id = ua.affiliation_id innerjoin UserWorkHistory uwh on u.user_id= uwh.user_id innerjoin Affiliations wa on uwh.affiliation_id = wa.affiliation_id;