SQL question

From: allen mcvickers <amcvicke_at_hotmail.com>
Date: 16 Jul 2001 14:56:33 -0700
Message-ID: <d225996a.0107161356.749dd61f_at_posting.google.com>

Hola!

    I'm taking an Intro to Oracle class and have a SQL problem that I need an answer to. Here goes:

     I have an employee table which includes, among others, a job column and
a deptno column, which includes several department numbers that relate to different departments(SALES, RESEARCH, etc). Those department names are a column (dname)in the dept table.

      The question  asks:
         Which jobs can be found in department 10, as well as

department 20, as well as in department 30?

         Would anyone care to take a shot at it?   
                               TIA, allen

Received on Mon Jul 16 2001 - 23:56:33 CEST