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