MySQL Join

  • Inner Join

  • left join

SELECT a.runoob_id, a.runoob_author, b.runoob_count FROM runoob_tbl a LEFT JOIN tcount_tbl b ON a.runoob_author = b.runoob_author;
1
  • right join

hive sql 中支持 full outer join

reference