SQL Question

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,
Ron Received on Tue Feb 03 1998 - 00:00:00 CST