title: How to make Table Joins in PHPmyAdmin
body: <p>I have 2 Tables in phpmyadmin that need joining</p>
  
  <p><code>tracklisting</code> is my one and <code>catelogue</code> is the other, and are saved as innodb</p>
  
  <p>They both have a column <code>CAT.NO</code> and would like it to be joined on this column. In catelogue it is the primary and in tracklisting it's indexed</p>
  
  <p><code>catelogue</code> is my parent and <code>tracklisting</code> would be the child as it doesn't have info for every record in catelogue. I believe this would be correct unless I'm wrong</p>
  
  <p>How do I do this so that when I query  on a column in <code>tracklisting</code> it only brings up the matches for 'catelogue' because I want to know what album it's on and not my entire 60000+ catelogue</p>
  
  <p>Can this be done with phpmyadmin's interface or is this a sql statement</p>
  
  <p>Many thanks</p>
  
  <p>EDIT:</p>
  
  <p>This was the code that worked</p>
  
  <pre><code>SELECT *
  FROM tracklisting
  INNER JOIN catelogue ON catelogue.`CAT NO.` = tracklisting.`TRACKLISTING CAT NO.`
  WHERE tracklisting.`ARTIST` LIKE 'placebo'
  </code></pre>
  
  <p>Thanks to everyone that helped out</p>