## inner join

[Originally posted by Croy]

I have 2 tables i want to connect by inner join.

one is &quot;Education_subects&quot; (has fields: &quot;subject_id&quot; & &quot;subject_desc&quot;), and the other table is &quot;employee_education&quot; (has fields: &quot;emoloyee_number&quot;, &quot;subject_id_1&quot;, &quot;subject_id_2&quot;).

now, i want to connect both fields &quot;subject_id_1&quot; & &quot;subject_id_2&quot; to the field &quot;subject_id&quot; in the first table.

how do i do it.
in other words, i do i connect 2 tables in more then one field?