hi,
i have 2 tables:
currencyrates
+-+++
| code char(3)|| currency char(3) |
| name varchar(10)|| rate double|
| bcurrency char(1) |
On Mon, 20 Aug 2001, Michiel Leegwater wrote:
> insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking,
> CRvan,CRtot,PR,Categorie from table2;
>
> This doesn't work, it says "Column count doesn't match value count at row 1"
> I understand the problem. But I can't use my ID colu
-
From: Michiel Leegwater [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 3:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Problem with INSERT INTO ... SELECT
Hello,
This is the situation:
Table1:
ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR
Hello,
This is the situation:
Table1:
ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR
Categorie
Table2:
Identical columns.
What is the problem? I'm trying to append all the values from table2 to
table1.
I was trying this SQL query:
insert into table1 s