Re: Inserting data from one table to another

Krzysztof,

Put the Table name between  double quotes "L_klienci_wysylka" or maybe 
to put the database name before the tablename "Basename"."Tablename"

Hope it helps

Fernand


> Hi everybody!
>
> I try to insert data from one table to another with:
>
> INSERT INTO L_klienci_wysylka ('id_klienta','data_wys')(SELECT
> 'ID','data_wys' FROM 'I_klienci')
>
> but I get:
>
> 4: Table not found in statement [INSERT INTO L_klienci_wysylka]
>
> I'm sure that table L_klienci_wysylka exist because I can enter the data
> manually.
> I am using OpenOffice Base 3.2.0
>
> Krzysztof
>
>