Inserting data from one table to another

Krzysztof Walkiewicz <[email protected]> Wed, 17 Feb 2010 14:07:02 +0100
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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