Subject RE: [firebird-support] How To Concatinate Multiple Rows Data Into Single One
Author Vishal Tiwari
Dear SET,
Hello Ya, How Are You?
A Heartful Thanks for this help.
o you came once again as usual :)
Just let me try once
With Best Regards.

--- On Wed, 1/9/10, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:

From: Svein Erling Tysvær <svein.erling.tysvaer@...>
Subject: RE: [firebird-support] How To Concatinate Multiple Rows Data Into Single One
To: "" <>
Date: Wednesday, 1 September, 2010, 1:57 PM


I would expect

SELECT Reader_Code, LIST(Book_Name)
FROM Reader_Books

to work from Firebird 2.1 onwards.


-----Original Message-----
From: [] On Behalf Of Vishal Tiwari
Sent: 1. september 2010 10:05
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
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.

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