Now and again I get to do something really interesting at work. This might not seem like a big deal to some, but I've never written any SQL before. SELECT ShoppingLists.Name, TransferPoints.Code, CustomerItems.CustomerItemCode, CustomerItems.CustomerItemDescription FROM ShoppingLists INNER JOIN ShoppingListItems ON ShoppingList.ID=ShoppingListItems.ShoppingListID INNER JOIN CustomerItems ON CustomerItems.ID=ShoppingListItems.CustomerItemID LEFT JOIN TransferPoints ON ShoppingLists.TransferPointID... read more