Re: please help me with these queries!
From: Jay Krishnamurthy <76326,712_at_compuserve.com>
Date: 1995/09/09
Message-ID: <42t6dc$5f5_at_data.interserv.net>#1/1
Date: 1995/09/09
Message-ID: <42t6dc$5f5_at_data.interserv.net>#1/1
MPONIKVAR_at_crete.hsc.colorado.edu (Marissa Ponikvar) wrote:
>(1) I need to list the stars' name(s) and the movie's title of all movies
>directed by either alfred hitchcock or john ford.
>
>Select starname, mvtitle
>from stars s, movies m, directors d, movstars r
>where s.starnumb=r.starnumb
>and m.mvnumb=rmvnumb
>and d.dirnumb=m.dirnumb
>and dirname = 'Hitchchock, Alfred' or
>dirname = 'Ford, John';
>
Try the "or" with a paranthesis ...
Select starname, mvtitle from stars s, movies m, directors d, movstars r
where s.starnumb = r.starnumb and m.mvnumb = r.mvnumb and d.dirnumb = m.dirnumb and (dirname = 'Hitchcock, Alfred' or dirname = 'Ford, John') ;
I'll take a look at the rest and will email if I find time ... Received on Sat Sep 09 1995 - 00:00:00 CEST