insert statement with left outer join??

[The_Oracle]

I am trying to write pl/sql syntax to insert data into one column by selecting data from another column where a third colum on table a is equal to a column on table b.