How to fill an empty table with data using a one-to-one relationship?

Question

SQL

There is an empty table that is related to another table (not empty) one to one. How can you write a query to fill an empty table with data so that all records are related to another - not empty - table?

Answer 1

INSERT INTO tab1 (id, enum_field)
SELECT id, 'opt1'
  FROM tab2