Обсуждение: creating a new table with data from other tables

Поиск
Список
Период
Сортировка

creating a new table with data from other tables

От
"Willian Jakobs"
Дата:
I have to create a table with data from other tables.
I dont how many tables, the tablesnames are:
student<00>, where 00 is a number. So I cant specify the table name.
The tables dont have primary keys.
And I only have to insert two fields into the new table.
All this is for a database in ms-access and I want to try to solve this
problem with SQL.
Please help me and i will thank u.

Willian Jakobs