I am using vb.net with sql client. i have on problm. i created one table with fields author1, author2, author3. Now i want to combine these three fields items into new table field Author.
all datas in author1,2,3 are will be listed one by one under author field.