Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id QAA16408 for pgsql-sql@postgresql.org; Tue, 4 May 1999 16:09:04 -0400 (EDT) (envelope-from news) X-Authentication-Warning: hub.org: news set sender to using -f From: Richard Chrenko Subject: how to get "autonumber" when using INSERT INTO Date: Tue, 04 May 1999 10:27:52 +0200 Organization: Internet Access AG, Zuerich, Switzerland Message-ID: <372EAF88.49FB@bluewin.ch> To: pgsql-sql@postgreSQL.org I'm trying what seems to me a trivial SQL task using Microsoft ADO to write an Access table. I have several default tables containing the same 20 fields (but different data). I want to append the contents of these tables into a "master" table which contains the same 20 fields in addition to an autonumber field such that each appended record has a unique identifier. The following SQL queries succeed when run directly from Access INSERT INTO mastertbl SELECT * FROM default1; INSERT INTO mastertbl SELECT * FROM default2; where mastertbl contains the same fields as default1 and default2 in addition to an autonumber field. However, when these queries are submitted via ADO from another application I get an error message that the number of fields are unequal. Please help me to get this to work using ADO!