You can try theLIST() function added in V.2.1.

Ionutz





________________________________
From: Vishal Tiwari <vishualsoft@...>
To: firebird-support@yahoogroups.com
Sent: Wed, 1 September, 2010 11:04:55 AM
Subject: [firebird-support] How To Concatinate Multiple Rows Data Into Single
One


Hi All,

I have one requirement, but before that let me explain the table structure:

I have a table say for example Books and it contains the books list as:

Table Name = Books

Book_Name
Book_A
Book_B
Book_C

I have another table Called Reader_Books, this would contain the no. of user
taken those books for reading, table structure is as follows:

Table Name : Reader_Books

Reader_Code Book_Name
R001 Book_A
R001 Book_B
R002 Book_A
R002 Book_B
R002 Book_C
R003 Book_A


I need the data in following manner:


Reader_Code Book_Name
R001 Book_A
R002 Book_A, Book_B, Book_C
R003 Book_A


I tried my efforts but no result, but still I would like to learn how to achieve
this.

I need to achieve above result only using SQL.

Thanks In Advance.


With Best Regards.

Vishal

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]