Ask Your question
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!
Search & Filtering
1. I need to know which of our sales reps don’t have any customers, all regions. (Hint: This is a different type of JOIN. Also, test for nulls and eliminate the managers.)
2. tell me which region managers are responsible for those sales reps who don’t have customers in all regions. Display the region ID, I can get the full name separately. (Hint: You’ll need to see the entire employee/customer list to provide this answer)
create a calculated field with the column label Discount Price that subtracts the Price times the Current Discount from the Price.
SELECT O.ORDERID, o.SALESPERSONID, S.SALESPERSONID
FROM ORDER_T o FULL JOIN SALESPERSON_t s
ON O.SALESPERSONID = S.SalespersonID
An INNER JOIN
A FULL JOIN
The ROLLBACK fails because it is only for UPDATE
Records from the table are deleted
The record(s) that were inserted do not get committed to the table
The records are left inconsistent
Only works when combined with a ROLLBACK.
Only works within a transaction.
not needed because the server always commits changes.
Makes changes outside a transaction permanen.t
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T RIGHT OUTER JOIN Order_T
ON Customer_T.CustomerID = Order_T.CustomerID
only rows that match both Customer_T and Order_T Tables
only rows that do not match both Customer_T and Order_T Tables
all rows of the Order_T Table regardless of matches with the Customer_T Table
all rows of the Customer_T Table regardless of matches with the Order_T Table