title: SQL Show fields that match WHERE statement otherwise show the others
body: <p>These are the parameters I am working with and I can get the entries to show up that match the Item 'Dress Shirt' but I don't know how to show the others if they don't match the 'Dress Shirt'.  I have been trying to use AND/OR but can't get it to show up right.</p>
  
  <p>"Show the LastName, FirstName, Phone and Total Amount of all customers who have had an order with an Item named "Dress Shirt".  Also show the LastName, FirstName and Phone of all other customers.  Present results sorted by LastName in ascending order and then FirstName in descending order."</p>
  
  <pre><code>SELECT LastName, FirstName, Phone, TotalAmount
  FROM Customer, Invoice, Invoice_Item
  WHERE Customer.CustomerID = Invoice.CustomerNumber AND Invoice.InvoiceNumber = 
  Invoice_Item.InvoiceNumber AND Item ='Dress Shirt';
  </code></pre>