How get the result of mysql query with condition
<p>teacher table</p>

<pre><code>teacher_id      teacher_name
============================
1               john
2               doe
</code></pre>

<p>student table</p>

<pre><code>student_id      student_name    student_score   teacher_id
==========================================================
1               amelia          0               1
2               anderson        0               1
3               fabiano         0               1
4               ronaldo         0               2
5               peter           6               2
6               alex            0               2
</code></pre>

<p>result</p>

<pre><code>teacher_id      teacher_name
============================
2               doe
</code></pre>

<p>the result is teacher record who one or more of his student score > 0.</p>

<p>How the query of this ?</p>

<p>thanks for the answer and sorry for my bad english</p>