I currently working with a DB where alot of the data is seperated in to multiple tables.
I am trying to merge or join 2 tables together that has the members info but I am unsure how to do this.
Each table has an id set as the primary key. I have already created the new table and transfered data from one of the tables over.
I have tried to use the insert command to move the data from the second table specifying that the id is the cell that needs to match as follows.
INSERT INTO member5 (id, chid, username, password, accesslvl) where ‘id’ = ‘id’ VALUES (x, x, x, x, x)
This errored out on me and I am trying to figure out how to make this work. I have looked at the upload command but am unsure how to make that work.
Any ideas on how I can merge the info into a single table would be appreciated.