From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Marcelo
Sent: Tuesday, September 30, 2008 22:55
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How to get detail strings all concatenated



Hi all!
I want to get a master record along with a concatenation of detail
strings in a single record.
How do I do it?
Greeting, Marcelo.

_

[PM] Try

Select m.Mastername||(select d.DetailName from DetailTable d where
d.MasterId=m.MasterId) from MasterTable m



Regards,

Paul





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