Re: Removing repeating columns in query?

Oops, I see that you are trying to break on two columns, the break keyword only works on one. If you don't mind having a repeating division or manager, then it will work. Otherwise, you'd need to use Access (cheap) report builder or Crystal Reports or something like that for the formatting.

Tom
www.oraclepower.com

"Pascal Byrne" <byrne_at_icada.com> wrote in message news:3C4DA49B.5AE9D7E_at_icada.com...
> Hi all,
> I need create a report ordered by a primary and secondary column that
> only
> displays each ordered column value once e.g.
>
> DIVISION MANAGER PROJECT
> -------- ------- -------
> Engineering John Doe WebMail
> Editor Pro
> RSM
> Joe Soap Hyperhub
> Accounts Bob Billings Ledger
>
>
> How can I do this in plain SQL?
>
> Thanks,
> pascal
>
>
Received on Tue Jan 22 2002 - 12:06:31 CST