can i use self join on table for insert new data

Question

if yes please give me just a example

thankzzz

Answer 1

INSERT table (column1, column2)
SELECT t1.column1, t2.column2
FROM table AS t1
JOIN table AS t2
ON t1.column1 = t2.column1
WHERE t1.column1 = 'value'