update column

[gogaak]

replicate column

helo all,

I have two tables I want to copy all the contentc of column in tableA to coumn in tableB. Both the columns are primary key of respective tables. .


One more doubt-- Can i have primary key of two tables with same name...
Example: Table A
columns( TokenID, Name, locatin, status)
Table B
columns( Token ID, DivisionID, DeptID)

( I suppose it doesnt make any sense to do this). But can it help in some situations?

 

[FoFa]

Why not just have TableB with it's own PK (maybe an autonumber) and then have a FK (Token ID) pointing back to tableA?

 

[gogaak]

thanx for the Info mate....
That definitely gave me some sense...