I am trying to create a SQL view that shows the order details from the SOPOrderReturn table, the email address on the order (if not using invoice address) from the SOPDocDelAddress table, and the main email address for the account (for use when there…