Insert data from one table to another
Hi,
I wish to populate one table from a query that I created:
The query has columns id, firstName, lastName where id is not an auto increment value rather it's a teacher's id.
I'd like to populate this data to a table with the columns:
id, firstName, lastName, teachers_id where id in this table is an auto increment value and teachers_id is from id of the query.
Much thanks,
vkimura
I wish to populate one table from a query that I created:
The query has columns id, firstName, lastName where id is not an auto increment value rather it's a teacher's id.
I'd like to populate this data to a table with the columns:
id, firstName, lastName, teachers_id where id in this table is an auto increment value and teachers_id is from id of the query.
Much thanks,
vkimura
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I found it. Great it works. Thank you.
ASKER
Thank you.
ASKER