title: replace inner join with select from, perhaps?
body: <p>I am trying to understand and modify an SQL query used by an input field to do a smart search.</p>
  
  <p>The original code is here:</p>
  
  <pre><code>((`clients` INNER JOIN `addresstorecord` ON `clients`.`uuid` = 
     `addresstorecord`.`recordid` AND `addresstorecord`.
     `tabledefid`='tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083' AND
      addresstorecord.primary='1') INNER JOIN 
    `addresses` ON  `addresstorecord`.`addressid` = `addresses`.`uuid`)
  </code></pre>
  
  <p>I do not actually need an inner join, as all my information is already in one table.</p>
  
  <p>In that case, could I theoretically just replace the inner join query with my table name? Or would I have to actually do a select from statement?</p>