creating a new table with data from other tables

From: "Willian Jakobs" <w(dot)w(dot)j(dot)jakobs(at)med(dot)rug(dot)nl>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: creating a new table with data from other tables
Date: 1999-05-17 12:11:51
Message-ID: 7hp128$a7p$1@info.service.rug.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message secret 1999-05-17 13:14:50 Re: [SQL] Oddities with NULL and GROUP BY
Previous Message Israel Zavalza Bahena 1999-05-17 11:00:03 Encriptacion en Bases de Datos