title: Returning another value if preferred value is null
body: <p>SQL noob here struggling with a query...</p>
  
  <p>I have two tables, one that contains product information (ItemCode, ItemName) and one that contains different price lists (up to 10) for each product.</p>
  
  <p>In plain English, this is what I want to achieve:</p>
  
  <pre><code>Select T0.ItemCode, T0.ItemName, T1.Price
  </code></pre>
  
  <p>Take the price from price list 6: if price in price list 6 is null, then take the price from price list 1 and deduct 5%</p>
  
  <p>It seems like it should be fairly straight forward but I'm not really sure where to begin to be honest I'd be grateful for some advice.</p>
  
  <p>Many thanks,
  Michael </p>