title: SQL join table with two 'ON' keyword?
body: <p>I have two tables tbl_a and tbl_b   and their fields are</p>
  
  <pre><code>tbl_a
  -----
  a_id a_name a_surname a_c_id a_d_id
  
  tbl_b
  -----
  b_id b_name b_phone b_c_id b_d_id
  </code></pre>
  
  <p>I want to join these two table like this:</p>
  
  <pre><code>select *from tbl_a join tbl_b on tbl_a.a_c_id=tbl_b.b_c_id AND tbl_a.a_d_id=tbl_b.b_d_id where tbl_a.id&gt;15;
  </code></pre>
  
  <p>As you can see i want to use two keys for ON keyword,is there anyway to do this?
  Thanks for advance...</p>