Sql Table classification or categorization and update over a table using inner join

Sql Table classification or categorization over a table

1- insert into Atable select from Btable

insert Example;

insert into Atable (title,...)
SELECT xtitle,... FROM Btable where 1 group by xtitle

2- update a table using inner join  

update Example ;

update Btable as a
inner join Atable as b
on b.title=a.xtitle
set a.x_id=b.id