title: How to handle SQL joins if missing rows on particular table exist
body: <pre><code>    SELECT
      fromData.name as fromname, toData.name as toName, prodData.prodname, 
      t1.`from_id`, t1.`to_id` , t1.`product_id` , t1.`title`, t1.`message`, t1.`senttime` , t1.`readstatus`, t1.`responded`, t1.`merchanthidden`
      FROM `inquiries` as t1 
      INNER JOIN users as fromData on t1.from_id = fromData.id 
      INNER JOIN users as toData on t1.to_id = toData.id 
      INNER JOIN products as prodData on t1.product_id = prodData.id 
      WHERE t1.id=13
  </code></pre>
  
  <p>Above query joins 3 tables (inquiries, users, products) together and gets data from each table. </p>
  
  <p>Sometimes it is possible that items in the 'products' table get deleted. Trying to join products table by a deleted product id will fail the query. </p>
  
  <p>Is there a way that I can assign '<strong>prodData.prodname</strong>' a default value and execute query without failing in case of a missing item in products table ? </p>