title: Subsonic - Simple Query
body: <p>I have a table has 2 columns</p>
  
  <p>Val1 int</p>
  
  <p>Val2 int</p>
  
  <p>My query very simple.</p>
  
  <p>I want to get collection of record have condition (val1=Val2) ,</p>
  
  <p>equivalent to (Select * from table where Val1=Val2)</p>
  
  <p>I try </p>
  
  <p>IDataReader rdr = new Query("Table").WHERE("Val1=Val2").ExecuteReader();
          tableColl.LoadAndCloseReader(rdr);
          rdr.Close();</p>
  
  <p>and</p>
  
  <pre><code>  ..WHERE (" 'Val1=Val2' ")
    ..WHERE (Table.Columns.Val1,IsEqualTo,Table.Columns.Val2) //This not reguler I know
    ..WHERE ("Val"+'='+"Val2") 
    .....
  </code></pre>
  
  <p>any help be more apricated.</p>
  
  <p>Thanks.</p>