SQL Question
From: Ron Many <rmany_at_pacbell.net>
Date: 1998/02/03
Message-ID: <34D772AD.FAB819E4_at_pacbell.net>#1/1
Date: 1998/02/03
Message-ID: <34D772AD.FAB819E4_at_pacbell.net>#1/1
I like to return information from several rows in a single row like
this:
I have a table with line items information that is the detail for an
invoice header table. each invoice has between 1 to 10 line items
referenced by an Invoice Number column. What I need to do is to create a
view with a single string contains all the item numbers of an invoice
concatenate.
I don't want to use cursor or PL/SQL since I like to include it in a
view.
Can I do it? any ideas how?
Thank You,