CREATE VIEW vw_user_profile AS SELECT A.user_id, B.profile_description FROM tbl_user A LEFT JOIN tbl_profile B ON A.user_id = b.user_id GO