Insert Same Data Twice in TABLE

[bullsb]

Hi,

I need to INSERT same data (Having the uniq ID and change in FName) twice in the same TABLE.

I am getting ID, FName from a Table Called Emp_Details (Pulling using SELECT) and ID, FName from the previous Page.

I want to INSERT this in to the same TABLE at a time. E.G.

ID - 428
FName - Badri
The above getting from DATABASE and below from previous page

ID - 428
FName - Shiva

Note - ID is same for both the FName. The point here is how to INSERT. Plz help

[buntine]

The ID field in your database should really be controlled by an incrementing primary key. This is much easier than trying to keep integrity programmatically.

Cheers.