question

[link text][1] [1]: /storage/temp/3062-sid-3-logical-model.docx So I was given this question:Please provide your SQL statement and the result set that is a list of relationship managers who are assigned to a vendor. Note that the list should be sorted alphabetically by last name in ascending order. My answer was: SELECT r.rm_id "Manager ID", r.rm_lname AS "Manager Last Name", v.v_num "Vendor ID", v.v_name "Vendor Name" from talbert3_relationship_manager r, talbert3_vendor v WHERE r.rm_id=v.rm_id ORDER BY "Manager Last Name"asc; I was then given this question:Please provide your SQL statement and the result set that is a list of relationship managers (ID and full name) who are not assigned to a vendor account. Note that the list should be sorted alphabetically by last name in descending order. My answer is: SELECT r.rm_fname "Manager FName", r. rm_lname AS "Manager LName", r.rm_id "Manager ID", v.v_num "Vendor ID" from talbert3_relationship_manager r, talbert3_vendor v WHERE r.rm_id<>v.rm_id ORDER BY "Manager LName" desc; I know my data so I know that the second part is incorrect, but i'm not really sure how to fix it. Thanks!