[libreoffice-users] SQL-Query Syntax in LO-3.6-Base

Hello,
I am trying to define a query in Base like...

insert into "anwesenheit" "a1"
 (select 
795,"a2"."persNr","a2"."anwesend","a2"."statAnw","a2"."abwGrund","a2"."mitfahrer","a2"."bemerkung"
  from "anwesenheit" "a2"
  where "a2"."veranstNr" = 796)

I get back the following error message:

SQL-Status: HY000
Fehler-Code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

What's wrong with my query?
Regards
Heinrich

Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted