Table1
ID INTEGER,
Name VARCHAR(40)

Table2
ID INTEGER,
Table1ID INTEGER, --foreign key.
Name VARCHAR(40)

SELECT
T1.ID,
T1.Name
CAST(LIST(T2.Name) as CHAR(100) as T2Names

FROM Table1 T1
LEFT JOIN TABLE2 T2 ON T1.ID=T2.Table1ID
GROUP BY T1.ID

---

 Comments

---

The problem was caused during the evaluation of the CLOB values for the CAST operation. By default, the LIST() function always generates CLOB values, and there was an issue with the way that the values were being cached from row to row in the result set.

---

 Resolution

---

Fixed Problem on 10/9/2011 in version 2.05 build 11

---

 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 LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial