Displaying query results as a single row....

Hi all,

I hope the following makes sense......

Is there any way in SQL*PLUS to display a number of rows returned by a query as a sinlge row/record?

For example the following scenario (made very simple for explanation) where Client_Table has a one to many relationshuip with the Rules_table:

Client_Table containes clients
Client A
Client B
Client C

Rules_Table containes rules for above clients Client A Rule 1
Client A Rule 2
Client B Rule 1
Client C Rule 1
Client C Rule 2
Client C Rule 3

In a simple join (say for client A) I will get:-   Client A Rule 1
  Client A Rule 2

WHAT I LIKE TO SEE RETURNED IS:-   Client A Rule 1 Rule 2

Thanks for your help.

Naeem.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 07 1999 - 04:28:26 CDT