Home -> Usenet -> comp.databases.oracle -> help with sql for a newbie

help with sql for a newbie

From: Dave <rheadfan_at_hotmail.com>
Date: 7 Feb 2002 16:06:26 -0800
Message-ID: <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 - 01:06:26 CET












Original text of this message