Content of tables:
1) Table:id_table has 100 entries
2) Table:reference_TABLE is empty
Now i want to insert in to reference_TABLE with reference name newbie,each id from id_table.
As we can see above we have 100 entries in id_table. Should i write 100 'inset into' statements to fill reference_TABLE or is there any other short cut to achieve this.