Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id IAA64083 for pgsql-sql@postgresql.org; Mon, 17 May 1999 08:20:21 -0400 (EDT) (envelope-from news) X-Authentication-Warning: hub.org: news set sender to using -f From: "Willian Jakobs" Subject: creating a new table with data from other tables Date: Mon, 17 May 1999 14:11:51 +0200 Organization: Rijksuniversiteit Groningen Message-ID: <7hp128$a7p$1@info.service.rug.nl> To: pgsql-sql@postgreSQL.org 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