Provide the customer last name, transaction type, employee last name, and amount

Question

Provide the customer last name, transaction type, employee last name, and amount for the transaction with ID = 6.

Account Type v ATID INT Desc VARCHAR (45) IntRate DOUBLE Transaction TransID INT TTID INT Transaction Type v AcctID INT Customer TMD INT Account EmpID INT CustID INT Desc VARCHAR(45) AcctID INT Amount DOUBLE FName VARCHAR (45) Desc VARCHAR(45) Timestamp DATETIME LName VARCHAR (450 CreateDT DATETIME HH---- Payer Payee VARCHAR(45) JoinDate DATE Balance DOUBLE Phone VARCHAR(10) ATIDINT Email VARCHAR(45) Indexes Employee v EmpID INT FName VARCHAR(45) LName VARCHAR(45) MgrID INT Department Customer Account V Title VARCHAR(45) I---- DeptID INT VARCHAR(45) Ho Description AcctID INT DeptID INT CustID INT StartDate DATE Primary BOOL Indexes

Explanation / Answer

SELECT Customer.LName, Transaction_Type.Desc, Employee.LName, Transaction.Amount

FROM Transaction
   INNER JOIN Transaction_Type ON (Transaction_Type.TTID = Transaction.TTID)
   INNER JOIN Employee ON Employee.EmpID = Transaction.EmpID
   INNER JOIN Account ON (Account.AcctID = Transaction.AcctID)
   INNER JOIN Customer_Account ON (Customer_Account.AcctID = Account.AcctID)
   INNER JOIN Customer ON (Customer.CustID = Customer_Account.CustID)

WHERE Transaction.TransID = 6

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.