insert statement with left outer join??

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.

Good for you! How is it going?