Link to article on Joins in T-SQl : Basics
sqlteam.com
Points
1) when using aggregates with joins take care to include the column, as aggregating on '*' i.e. the row, might return false result specially for columns with null values.
2) when executing multiple joins using the left outer joins may be useful as using inner join might not return some rows with NULL values in the intermediate table.
Showing posts with label T-SQL. Show all posts
Showing posts with label T-SQL. Show all posts
Tuesday, June 10, 2008
Subscribe to:
Posts (Atom)
Posts
