I want to get data from two tables.my query is giving data but WHERE clouse is not giving me data which i want
<p>i have two tables DISCIPLINE and SUBJECT.</p>

<p>DISCIPLINE table has _DISCIPLINE_ID as a primary key and a DISCIPLINE_Name column.</p>

<p>SUBJECT table has _SUBJECT_ID as a primary key SUBJECT_Name and DISCIPLINE as a Forign key.
i want to select Subject from SUBJECT table Who has the same _DISCIPLINE_ID in the DISCIPLINE table.</p>

<p>here is my query:</p>

<pre><code>SELECT DISCIPLINE._DISCIPLINE_ID,
       SUBJECT.SUBJECT_Name 
FROM DISCIPLINE,
     SUBJECT 
WHERE SUBJECT.DISCIPLINE = DISCIPLINE._DISCIPLINE_ID
</code></pre>

<p>it gives me data but it selects all the Subjects and DISCIPLINE.</p>
