Selecting row from two table
<p>please can anyone help me, I am familiar with PHP but I'm not good in it.please help. I have two table and both have <code>id</code>, see sample,</p>

<p><strong>Table1</strong></p>

<pre><code>----------------------------------
   **ID**   |   **NAME**     |   **AGE**    |
----------------------------------
  001   |   john     |    21     |
----------------------------------
  002   |   erik     |    18     |
----------------------------------
  003   |   ella     |    19     |
----------------------------------
and soon...
</code></pre>

<p><strong>Table2</strong></p>

<pre><code>----------------------------------
   **ID**   |   **SUBJECT**     |   **GRADE**    |
----------------------------------
  001   |   math     |    80     |
----------------------------------
  003   |   english     |    83     |
----------------------------------
and soon....
</code></pre>

<p>here is the problem, I just want to select a row from table1 were its <code>id</code> dont match in table2.</p>

<p>I used this condition but it wont work the way I expected to so that means this is wrong,</p>

<pre><code>if($t1_id!=$t2_id){
blah blah blah...
}
else
{
all data is match!
}
</code></pre>

<p>when an <code>id</code> in table2 matched in table1 it already show that my <code>data is all match</code> even if there is only one entry in table2.</p>

<p>Please help me. If you don,t understand how I show my problem please tell me,THANK YOU!.</p>