Hi,
   The sql
     create memory table test1 as  select  * from table1 inner join
table2...  not persistent
   can not work....

   1 Remove the "not persistent" ,it can work....
   2 Remove the join ,it can work... Create memory table test1 as
select  * from table1 not persistent  also can work..
  Does the create memory table can't use the complicate select (such
as join) with "not persistent " option....?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to