You have an Azure SQL database that contains two tables named SalesOrders and SalesOrderDetails. You load the SalesOrders and SalesOrderDetails tables into Power BI Desktop. The tables have a relationship based upon the SalesOrderID column. You need to combine the two tables into one table. The solution must meet the following requirements: There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrders row. For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrders row data if the SalesOrder row exists. Any SalesOrder row data that does not have corresponding SalesOrderDetails rows is not included in the resulting table. What should you do to combine the two tables?Select only one answer. Append the tables. Merge the tables using the full outer join kind based on the sales order id. Merge the tables using the inner join kind based on the sales order id. Merge the tables using the left outer join kind based on the sales order id.