>Hi Cetin!
>
>Yeah, I know how to do it in a report form. What I'm trying to do is end up with a cursor that looks like this:
>
>
>Company Divsion
>JOHN SMITH, INC. WEST
> SOUTH
> EAST
>
>Instead of:
>JOHN SMITH, INC. WEST
>JOHN SMITH, INC. SOUTH
>JOHN SMITH, INC. EAST
>
>I know there are other ways to do it, but is there a way to do it in ONE SQL statement, maybe using UNION or something??
>
>-thanks

Kevin,
Your intention wasn't a ONE SQL as I could see. Anyway if I really ever needed to do it in one SQL this would be one way :

SELECT a.cust_id as sort1,b.order_id as sort2, ;
 a.cust_id, a.company, b.order_id,b.to_name;
 FROM  customer a INNER JOIN orders b ;
   ON  a.cust_id = b.cust_id ;
   where order_id = ; 
(select min(order_id) from orders C where b.cust_id = c.cust_id) ; 
union ;
SELECT a.cust_id as sort1,b.order_id as sort2, ;
 '' as cust_id, '' as company, b.order_id,b.to_name;
 FROM  customer a INNER JOIN orders b ;
   ON  a.cust_id = b.cust_id ;
   where order_id # ; 
(select min(order_id) from orders C where b.cust_id = c.cust_id) ; 
order by 1,2

Cetin