SQL Server Performance Forum – Threads Archive
left outer join and rulesIs there any rules that we should follow when doing a left outer join? I’m getting mixed results when I swap the table in the query. Should left table always have more rows than the right table?
maybe this link’s explanation can help:
Microsoft SQL Server MVP