title: MySQL - Select Info based on many tables
body: <p>I need to do the following:</p>
  
  <p><strong>Select Usernames</strong> from table <strong>delivery</strong> where <strong>date>"2012-06-01 00:00:00"</strong> then get <strong>IP</strong> from <strong>Customers</strong> order by IP and <strong>remove duplicated usernames</strong> (all based on the first usernames select).</p>
  
  <pre><code>select Username from delivery where date&gt;"2012-06-01 00:00:00"
                          INNER JOIN Customers d
                          ON c.Username = d.Username order by IP asc;
  </code></pre>
  
  <p>It isn't working, any idea?</p>
  
  <p><strong>EDIT:</strong>  </p>
  
  <pre><code>select Username from delivery c
      INNER JOIN Customers d
      ON c.Username = d.Username 
  where date&gt;"2012-06-01 00:00:00"
  order by IP asc;
  </code></pre>