you see that INNER JOIN does not satisfy the requirements. Explain why and describe which type of SQL JOIN is the most appropriate to satisfy both requirements? (An answer up to 40 words is sufficient) ， due to GDPR “right-to-be-forgotten” requests). Management has asked you for a report that has all the columns from both tables. The report must meet both of the following requirements: Every customer currently in the customers table should appear in the output， You are working with an e-commerce database that contains the following two tables: TABLE customers id INT PRIMARY KEY firstName VARCHAR(50) NOT NULL email VARCHAR(50) NOT NULLTABLE orders id INT PRIMARY KEY customerId INT orderDate DATE NOT NULL totalAmount INT NOT NULL FOREIGN KEY (customerId) REFERENCES customers (id) Over the years， even if its customer's id no longer exists in the customers table (the customer-related columns should be NULL). On your initial attempt to create a query， some rows in the orders table still reference id's from customers table that have been deleted (for example， even if they have never placed an order (their order-related columns should be NULL). Every order in the orders table should appear in the output，。

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。