Update into a table (with number 1 to 10)

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

I have 2 tables (tb_A & tb_B) - (dummy Scenario
------------------------------------------------------------------------------------
tb_A: Has two columns

(Serial_no = running number, P_Name = all blank)

Serial_no P_Name
1
2
3
4
5
6
7
8
9
1
----------------------------------------------------------------------------------
tb_B: only one column (no primary key and filled with records)

Full_Name

Allen Storsen
Leo Tenseen
Steven Woods
Michael Benz
Josef Jones

------------------------------------------------------------------------------------
I want to :

Insert data in "tb_B" into "tb_A"

so that I'll have a new view with names and their Random ID.


The order of the ID and Names is NOT important at all.



I just want to insert the names into tb_A with Running numbers.



Thanks a lot!
 
Change the data type of the Serial_No in table A to an Autonumber (There must
be no data in the table to do this) then append your names in table 2 to the
P_Name in table 1 and the numbering will take care of itsself.
 
Back
Top