On Wed, Sep 14, 2011 at 18:52, Olaf Kluge <olaf.kluge@...> wrote:

> We select some records in some tables and joins. In one Table, there are two
> records with different values. So I have by grouping this two records every
> time.
>
> It is possible?
>
> Select a.field, b.field, (c.field  record 1 and c.field record 2 in one
> string) from tabelle a left join tabelle b on a.id = b.id..?

Maybe the LIST function can help?

Look at its documentation in
Firebird_2_1\doc\sql.extensions\README.list.txt

One example from there is this:
SELECT TAG_TYPE, LIST(TAG_VALUE)
FROM TAGS
GROUP BY TAG_TYPE

HTH,
Markus