By tag: joins
Ban this user: Options
Please provide a reason for deleting this story
Recently i'm seeing a lot of questions about how to modify data in the tables which are part of the multi-join select statement. And i keep wondering how can this be so hard to remember. The methodology is quite simple.
When using an OUTER JOIN, you should put criteria on the outer table in the join condition, not in the WHERE clause. However, I often see a "workaround" to avoid this simple and solid rule, which might seem to work but actually doesn't. Since it is hard to explain why over and over in foru...