title: query that will get me the item name and item category name for all in orderID 12345
body: <p><a href="http://i.stack.imgur.com/36mpk.png" rel="nofollow">I need help in writing a query that will get me the item category name for all items in this list. Even if it is null like Item.categoryID it should still give me back the names.</a></p>
  
  <p>The syntax is Select * FROM and then the names of the tables? Maybe? Or join them all into one table and return the names.</p>