johnkainn
asked on
Data to new table
I have
Table1 T1Id, T2Id, T1Text, T1Password,T3Id
Table2 T2Id, T2Text.
I add another table i.e. empty table.
Table3 T3Id, T3Text,Password
I want to create a new row in Table3 for each row in Table1.
I want to update the column T3Id in Table1 with the T3Id of the new row in Table3.
I want also to set Table3.Password=Table1.T1P
How is best to do this?
Table1 T1Id, T2Id, T1Text, T1Password,T3Id
Table2 T2Id, T2Text.
I add another table i.e. empty table.
Table3 T3Id, T3Text,Password
I want to create a new row in Table3 for each row in Table1.
I want to update the column T3Id in Table1 with the T3Id of the new row in Table3.
I want also to set Table3.Password=Table1.T1P
How is best to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.