Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Unanswered: SQL commands question in apex oracle workshop

    SELECT Make, Model
    FROM CAR
    WHERE EMPID = SELECT EMPID
    FROM EMPLOYEE
    WHERE DEPTID = SELECT DEPTID
    FROM DEPARTMENT
    WHERE DEPTNAME = 'COMPUTING';

    ORA-00936: missing expression
    I can't get the makes & models of cars belonging to employees in the computing department, any help?

  2. #2
    Join Date
    Dec 2007
    Posts
    253
    Put parentheses around you subqueries

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    each SELECT can have only single FROM

    When all else fails Read The Fine Manual

    SELECT
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •