i want to merge two rows in a table. but a little confused.. Please help!:confused:
the example is as shown below
Record #1: Nikhil Bhat 1Jan2009 Married ABC
Record #1: Nikhil Ong 1Feb2009 Single DEF
Record : Nikhil Ong 1Jan2009 Married DEF
There is a primary key 'ID' which is also auto incremented.