here is the details,
1) inner join or join, its behavior is same, so there will be no effect if you replace inner join with join.
2) parenthesis will not change its behavior, because we have only two conditions in where clause to check, parenthesis will play role when you will have multiple combination of OR and AND operators.
so, i believe code is correct,
master your setup, master yourself. http://mssqlsolutions.blogspot.com