title: SQL Inner Join Won't Select Data on Live server
body: <p>I'm having a massive issue with a <strong><code>SELECT</code></strong> statement using multiple <strong><code>INNER JOINS</code></strong>, I'm wondering whether i'm being really silly with my syntax or not!</p>
  
  <p>Here's the SQL Statement:</p>
  
  <pre><code>SELECT DISTINCT Users.ID FROM Users INNER JOIN File ON Users.ID=File.ID 
  INNER JOIN Purchased ON File.ObjectID= Purchased.ObjectID
  </code></pre>
  
  <p>The Users table contains the id:</p>
  
  <pre><code>1234
  </code></pre>
  
  <p>The File Table contains an id of:</p>
  
  <pre><code>1234
  </code></pre>
  
  <p>It also contains an ObjectID of:</p>
  
  <pre><code>4567
  </code></pre>
  
  <p>The purchased table contains the ObjectID of:</p>
  
  <pre><code>4567
  </code></pre>
  
  <p>The problem only seems to occur on the live server, on the local server this query works fine!</p>