Re: help with sql for a newbie

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 Fri Feb 08 2002 - 04:28:42 CET