table1 table2
col1 col2 col3 col4
1 a 1 a
2 b 2 b
null c 3 c
4 null null d
inner join result:
col1 col2 col3 col4
1 a 1 a
2 b 2 b
left outer join result:
col1 col2 col3 col4
1 a 1 a
2 b 2 b
null c null null
4 null null null
full outer join result:
col1 col2 col3 col4
1 a 1 a
2 b 2 b
null c null null
4 null null null
null null 3 c
null null null d
Showing posts with label joins in sqlserver. Show all posts
Showing posts with label joins in sqlserver. Show all posts
02 January 2012
Subscribe to:
Posts (Atom)