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;

• right join

hive sql 中支持 full outer join

reference

• [1] 菜鸟教程.MySQL 连接的使用open in new window