Take Control of Joins

(Itzik Ben-Gan) When you write a multitable join that uses inner joins exclusively (or for that matter, only cross joins or only full outer joins), the table order you specify in the FROM clause doesn’t affect the query result. However, when you’re using left or right outer joins, if you revise the

Read More - Register for Free Membership