SQL Join
Apr 26, 2021
第一次寫SQL query
分不清 Inner Join, Left Join, Right Join
Inner Join: join rows which met the conditions in tableA and tableB
Left Join: 保留left所有rows ->再join right rows
Right Join: similar
第一次寫SQL query
分不清 Inner Join, Left Join, Right Join
Inner Join: join rows which met the conditions in tableA and tableB
Left Join: 保留left所有rows ->再join right rows
Right Join: similar