>Could you post some example data and desired result?
>
>I understand your question this way:
>

>SELECT * 
>    FROM MasterTable
>INNER JOIN ChildTable ON MasterTable.PK = ChildTable.FK AND
>                         ChildTable.SomeField1 = ????   AND
>                         ChildTable.SomeField2 = ????
>

>
>BTW this will give you the same results as:
>

>SELECT * 
>    FROM MasterTable
>INNER JOIN ChildTable ON MasterTable.PK = ChildTable.FK
>WHERE ChildTable.SomeField1 = ????   AND
>      ChildTable.SomeField2 = ????
>

>Only if you have LEFT/RIGHT join then it is important where you put the condition.

Yes, this is exactly what I tried at first but was not unable to avoid some records to be part of the SQL result.