Hi,

I have the follow select in my TIB_Query:

SELECT CODE_ANIMAL,(SELECT LIST(R.NAME,',') FROM RACIAL_COMPOSITION INNER JOIN RACES R ON ID_RACE = RACIAL_COMPOSITION.FG_ID_RACE AND RACIAL_COMPOSITION.FG_ID_ANIMAL=ANIMALS.ID_ANIMALl) AS RACIAL_COMP

I need to show the racial composition of the animals and when the racial composition has more than a race then the races must be separated by comma.
But the content of the field does not appear, it appears only RACIAL_COMP.

Anybody can help me ?