Question 115 pts Code example 3-1 SELECT vendorName, invoiceNumber, invoiceDate,

Question

Question 115 pts

Code example 3-1
SELECT vendorName, invoiceNumber, invoiceDate, invoiceTotal
FROM vendors INNER JOIN invoices
    ON vendors.vendorID = invoices.vendorID
WHERE invoiceTotal >= 500
ORDER BY vendorName DESC

(Refer to code example 3-1.) What table(s) does the data in the result set come from?

Flag this Question

Question 125 pts

Which of the following can a SELECT statement not do to the data in a table?

Flag this Question

Question 135 pts

Which of the following is not a common MySQL data type?

Flag this Question

Question 145 pts

A join that returns records from related tables only if their related fields match is called

Explanation / Answer

Answer:

vendors and invoices

125)

an inner join

145)

135)

DBL

145)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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