SQL join statement, issues
<p>I'm new to SQL and thus not able to compose the <code>JOIN</code> statement for this query.</p>

<p>I've the following two tables </p>

<pre><code>Teachers

+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(11)     | NO   | PRI | NULL    | auto_increment |
| first_name  | varchar(30) | NO   |     | NULL    |                |
| last_name   | varchar(30) | NO   |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+

Courses

+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | int(11)     | NO   | PRI | NULL    | auto_increment |
| teacher_id | int(11)     | NO   | MUL | NULL    |                |
| name       | varchar(30) | NO   |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
</code></pre>

<p>I want to write a Java <code>PreparedStatement</code> string to query that <code>given a course id the details of the teacher for the course is returned</code>. Can someone help writing this.</p>