[Originally posted by Croy]

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

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

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

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