Is it possible to do a JOIN with a memory table and a regular table
like you could with DBISAM? As far as I can tell you can't because
they are in different databases.

Michael

> Is it possible to do a JOIN with a memory table and a regular table
> like you could with DBISAM? As far as I can tell you can't because
> they are in different databases.

Yes, it is possible.

Just deal it like DBISAM with just a little difference. Instead of using
memory\table you should use the name of memory database plus "." and the
name of the table.

For example:
select field1, field2, memory.field1 from table1 t
inner join memory.table1 m on (t.field1 = m.field1)
order by memory.field1

This is applyed too for any kind of database. You can use memory database as
a regular disk database.

Eduardo