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