Results 1 to 2 of 2

Thread: Help With Date

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Help With Date

    Hi people, i am trying to get this done:

    select e.lname
    from employee e, department d
    where e.ssn = d.essn and months_between(sysdate,e.bdate) <= all(select months_between(sysdate,e2.bdate)
    from employee e2,department d2
    where e2.ssn = d2.mgrssn);

    and this is the error it gives me:
    4* where e2.ssn = d2.mgrssn)
    where e.ssn = d.essn and months_between(sysdate,e.bdate) <= all(select months_between(sysdate, e2.bdate) from employee e2, department d2
    *
    ERROR at line 3:
    ORA-00904: invalid column name

    could someone tell me why?
    thankyou soo much

  2. #2
    Join Date
    Oct 2003
    Location
    Belgium
    Posts
    2
    At the end of your third line you put "(sysdate,e2.bdate)"; only you call upon e2 on the next line: from employee e2 ...

Posting Permissions

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