>SELECT * > FROM MasterTable >INNER JOIN ChildTable ON MasterTable.PK = ChildTable.FK AND > ChildTable.SomeField1 = ???? AND > ChildTable.SomeField2 = ???? >>
>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.