Re: help with sql for a newbie

I think what he is looking for is a way to break on the name. You can do that in SQL*Plus, with the break option (can't remember the syntax though).

Paul Quenneville wrote:
>
> break on directorname;
> SELECT DirectorName as Director, FilmName as Film
> FROM direct, films
> WHERE directorid=direcid;
>
> "Dave" <rheadfan_at_hotmail.com> wrote in message
> news:506fbed8.0202071606.5c894f28_at_posting.google.com...
> > hi, just wondering if anyone can help with a
> > problem i'm having - is it possible to achieve
> > the following style of results:
> >
> >
> > Director Film
> > ======== =====
> > Steven Spielberg Jurrasic Park
> > E.T.
> > Quentin Tarrantino Rervoir Dogs
> > Pulp Fiction
> >
> >
> > instead of what i am currently achieving:
> >
> > Director Film
> > ======== =====
> > Steven Spielberg Jurrasic Park
> > Steven Spielberg E.T.
> > Quentin Tarrantino Rervoir Dogs
> > Quentin Tarrantino Pulp Fiction
> >
> >
> > using a piece of code like:
> >
> > SELECT DirectorName as Director, FilmName as Film
> > FROM direct, films
> > WHERE directorid=direcid;
> >
> > in other words, i don't want the repetiton of
> > the director name. sorry if this is *really*
> > obvious....
Received on Sat Feb 09 2002 - 19:14:50 CET