Profile cover photo
Profile photo
Jason Chien
40 followers
40 followers
About
Jason's posts

Post has attachment
我的小波波
Photo

Post has attachment
我的小文青....
Photo

Post has shared content
不錯的說明
Difference between LEFT and RIGHT 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.  See more here http://javarevisited.blogspot.com/2013/05/difference-between-left-and-right-outer-join-sql-mysql.html
#Oracle   #MySQL  
Photo

Post has attachment
我在#googlebirthday 遊戲贏得糖果!我的分數: 150

Post has attachment
我在#googlebirthday 遊戲贏得糖果!我的分數: 132

Post has attachment
我在#googlebirthday 遊戲贏得糖果!我的分數: 117

Post has attachment
Louis Armstrong A Kiss To Build A Dream On。

Post has attachment

Post has attachment

Post has attachment
雪山 三六九山莊
Wait while more posts are being loaded