Profile

Cover photo
Dan McFarlane
Worked at M&M Meat Shops Ltd.
Lives in Canada
35,603 views
AboutPostsPhotosVideos

Stream

Dan McFarlane

Shared publicly  - 
 
Simple picture, complex understanding
 
Best way to understand difference between RIGHT and LEFT Outer Join in SQL
One of the most confusing concept to master in SQL is Joins, I find it quite similar to Recursion, some heads picks it up naturally but others can't even after lot of practice. This is one reason why Join is popular on any SQL interviews. One of the frequently asked question is Difference between RIGHT and LEFT Outer join, some will simply ask difference, others will ask you to write query. In Outer Join, non-matching records are also included in final result and depending upon, whether you are using RIGHT or LEFT outer join, non-matching rows from corresponding tables are included and for null is used to fill values for columns which comes from other table. 
http://javarevisited.blogspot.com/2013/05/difference-between-left-and-right-outer-join-sql-mysql.html
#MySQL   #SQLServer  
1 comment on original post
1
Add a comment...

Dan McFarlane

Shared publicly  - 
 
#sao super awesome
1
Add a comment...

Dan McFarlane

Shared publicly  - 
 
Lol
1
Add a comment...

Dan McFarlane

Shared publicly  - 
 
Awesome looking skin
1
Add a comment...

Dan McFarlane

Shared publicly  - 
 
Jousting and fair day...woot. +Stephen Fletcher
1
Add a comment...

Dan McFarlane

Shared publicly  - 
1
Rachel McFarlane's profile photo
 
Very cool
Add a comment...
 
#sao Awesome!
 
What happens when you make me mad
View original post
1
Add a comment...

Dan McFarlane

Shared publicly  - 
 
Buwhahahahahaha so funny
1
Add a comment...
 
Merry Christmas!
1
Add a comment...

Dan McFarlane

Shared publicly  - 
 
Awesome
1
Add a comment...
Work
Occupation
Senior Software Developer
Employment
  • M&M Meat Shops Ltd.
    Software Developer, 2014 - 2015
  • Retailigence
    Senior Software Developer, 2013 - 2014
Basic Information
Gender
Male
Relationship
Married
Story
Introduction
I am a super Geek, with a capital 'G'
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Canada
Apps with Google+ Sign-in