copying table field data to another table field

Question

how can i copy from one field entry data to another table fields....in sql database i have one table known as productdetails and its field ProductName i want new table from Productdetails Table field known productDescription and its field productName1ProductName2......productnameN(its contain value of ProductName column) please help me..

kannan · Answer

Hi vaquas Why you go for second table? I suggest you to simply add one column productDescription in your existing table productdetails . Hope it helps you!