On Wed, Sep 14, 2011 at 18:52, Olaf Kluge <olaf.kl...@satron.de> 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
