title: SQLITE query, return records from multiple tables each joining their own metatable
body: <p>I am developing a new database backend for my application for more flexibility.</p>
  
  <p>Instead of one large table with many columns, I now have four tables;</p>
  
  <ul>
  <li>Table "roms" (contains a single column 'Name')</li>
  <li>Table "romsmeta" (contains columns 'Name','Title','Year')</li>
  <li>Table "software" (contains columns 'System' and 'Name')</li>
  <li>Table "softwaremeta" (contains columns 'System','Name','Title','Year')</li>
  </ul>
  
  <p>So now I need to use a JOIN type in my queries, but my skills are a bit rusty. Basically, I would like to perform the following pseudo-query;</p>
  
  <p>SELECT Title,Year from (roms INNER JOIN romsmeta,software INNER join softwaremeta) WHERE Title like '%enteredTitle%'</p>
  
  <p>Obviously, this syntax is not valid. </p>
  
  <p>What query would return the results I'm looking for?</p>
  
  <p>Thanks in advance!</p>