title: complicated nested if statement
body: <p>I am hoping that someone can modify my existing query and provide me the SQL for me to copy and paste based on my 2 conditions listed below.  Thank you very much in advance, Nathaniel</p>
  
  <p><strong>condition#1</strong>. compare the values of the following 3 fields and output the lowest value of the 3 fields (exlcuding null values):</p>
  
  <p>"lowest list price"<br>
  "lowest price sold"<br>
  "lining_price_exception"  </p>
  
  <p>example: if "lowest list price" = 3 and "lowest price sold" = 7 and "lining_price_exception"  =null, then the output should be 3.</p>
  
  <p><strong>conditon#2</strong>. if the value in the field  "overide_price" is not null, then the field "overide_price" should replace the output from from condition #1. if the value in "overide_price" is null, then output the value from condition#1.</p>
  
  <pre><code>SELECT q.Part_ID, q.[lowest list price], q.[lowest price sold], 
         q.lining_price_exception, q.overide_price
  FROM qry_to_determine_wmx_price_01 AS q;
  </code></pre>