title: Select data from one table where a field is greater than that of another field in another table
body: <p>I want to be able to select data from TableA where Field1 is greater than Field2 in TableB.</p>
  
  <p>In my head i image it to be something like this </p>
  
  <pre><code>    Select TableA.*
      from TableA
      Join TableB 
      On TableA.PK = TableB.FK
  
      WHERE TableA.Field1 &gt; TableB.Field2
  </code></pre>
  
  <p>I am using SQL server 2005 and the TableA.Field1 and tableB.Field2 look like:</p>
  
  <pre><code>2004102881010 - data type - Vrachar 
  </code></pre>
  
  <p>My PK and FK look like:</p>
  
  <pre><code>0908232      - data type - nvarchar
  </code></pre>
  
  <p>The probelm is when this query is ran ALL the data is displaying and not just the rows where Field1 is greater.</p>
  
  <p>Cheers:)</p>