One To Many - Single Row Query Selection

[ihda]

I need to execute a view statement to do the following:

Table A
Loan_Number
Loan Officer

Table B
Loan_Number
Borrower_Name

Table A Values
Loan Number: 123
Loan Officer: FRANK


Table B Values
Loan Number: 123
Borrower Name: SMITH

Loan Number: 123
Borrower Name: JONES

Query Output Needed:
123 FRANK SMITH,JONES

Is it possible to concatenate contents from Table B and produce one row?

Thank you.

 

[BJCooperIT]

In various forms this problem has been addressed many times. Check out thread759-940836.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus