>You can put your condition into JOIN condition or INTO where, the result will be the same.
>
>select M.*, C.* from Master M inner join Child C on M.PK = C.FK and C.SomeField > 0
>
>or
>
>select M.*, C.* from Master M inner join Child C on M.PK = C.FK
>where C.SomeField > 0
>
>If you're talking about LEFT JOIN, then the situation is different and you only can place condition into JOIN condition to get correct results.
I tried that several times and was not able to avoid those records to be part of the result. I tried both approaches as mentioned here. I also tried WHERE primarykey NOT IN () and vice versa.