Combine one column data from one table to another table

I got two table that tableOLD have data that need to merge and put inside tableNEW by using SQL Query

!!!Prefer using Loop

data from tableOLD:

+-----+-----+
|  A  | Ant |
+-----+-----+
|  A  |Angel|
+-----+-----+
|  B  | Beg |
+-----+-----+

result need to have in tableNEW:

+-----+--------------+
|  A  | Ant and Angel|
+-----+--------------+
|  B  |     Beg      |
+-----+--------------+

Anyone can help on this.. thanks


Source: sql

Leave a Reply