it allows you to insert ids last names and job ids of the sales staff from the view if it is used in multitable insert statements