pgsql 关于inner join的用法

# select用法
select a.*, b* from a inner join b on a.id = b.id;

# update用法
update a set name = b.name from b where a.id = b.id;