I was attempting to do the following code -
SELECT First_Name, Last_Name
FROM Customers
WHERE CustomerNumber IN
(SELECT CustomerNumber
FROM Invoice
WHERE InvoiceNumber IN
(SELECT InvoiceNumber
FROM Invoice_Item
WHERE Item="Dress Shirt'))
ORDER BY Last_Name;
For some reason, I kept getting syntax error starting in (SELECT CustomerNumber - I am trying to figure out why.