|
|
submitted by
jimrice14
1 year, 6 months ago weblogs.sqlteam.com — 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 forum posts, I thought it might be helpful to address that here once and for all with an example.
| 
|
tags:
Programming, joins, SQL, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
Add a live kick counter to your blog >>
![liveImage]()
You can even customize the image by choosing your own colors, and then clicking
the button below to update the preview and the html code:
Simply copy and paste this HTML into your blog post.
Users who kicked this story:
No comments so far
|