Re: please help me with these queries!

From: Jay Krishnamurthy <76326,712_at_compuserve.com>
Date: 1995/09/09
Message-ID: <42t6fm$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

Original text of this message