'How to get 4 specific column in a table and transfer in another table using vb.net

I have a sql table with multiple column what i want is to transfer the value of 3 columns into another table.

sample table1

id numbers section firstname lastname age address 1 2 venus joseph bitangol 18 san francisco 2 5 mars danny bartulome 18 san diego another table2

id section age address 1 venus 18 san francisco 2 mars 18 san diego

Please help thanks in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source