title: Get info using table Joins with 2 MySQL tables and DISTINCT
body: <p>I have two tables: the <strong>'bidders'</strong> and <strong>'solditems'</strong> tables.</p>
  <p>The solditems table has 2 columns I need to use: <em>buyerid</em> and <em>paidstatus</em>.
  In the bidders table, I want to get the info from columns: <em>bidnum</em>, <em>bidfname</em>, <em>bidlname</em>, <em>bidphnum</em>.  (the 'buyerid' values in sold items corresponds with 'bidnum' in bidders)</p>
  <p>I'm trying to get unique buyer numbers from the solditems table with <em>paidstatus</em> marked as <em>unpaid</em>, and then get those buyers' info (fname, lname, and phnum) from the bidders table.</p>
  <hr />
  <p>This is what I have right now:</p>
  <pre><code>SELECT 
        DISTINCT(i.buyerid), 
        b.bidfname, 
        b.bidlname, 
        b.bidphnum 
  FROM 'solditems' AS i 
  INNER JOIN 'bidders' AS b ON i.buyerid = b.bidnum 
  WHERE i.paidstatus='unpaid' 
  ORDER BY i.buyerid ASC
  </code></pre>
  <p>If I use that in phpmyadmin sql section to test it, I get an error that says:</p>
  <h1>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''solditems' AS i INNER JOIN 'bidders' AS b ON i.buyerid = b.bidnum WHERE i.paids' at line 1</h1>
  <p>I've never done any joins before but I just can't seem to get this working.</p>