SCRIPT
BEGIN
   DECLARE ResultCursor CURSOR WITH RETURN FOR ResultStmt;
   USE MemoryDB;
   EXECUTE IMMEDIATE 'CREATE TABLE M1 AS select * from Test.Customer
where State=''CA'' WITH DATA';
   EXECUTE IMMEDIATE 'CREATE TABLE M2 AS select * from Test.Customer
where State=''CA'' WITH DATA';
   USE Test;
   PREPARE ResultStmt FROM 'select * from orders a
inner join MemoryDB.m1 on (a.custno=m1.custno)
inner join MemoryDB.m2 on (a.custno=m2.custno)';
   OPEN ResultCursor;
END

---

 Comments

---

The cause of the problem is the reference to the different database MemoryDB in the joins for the SELECT statement.

---

 Resolution

---

Fixed Problem on 4/6/2008 in version 1.09 build 2

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial