[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Why won't this work?

It's late and I know I should be able to solve this but...

SQL> SELECT * FROM PS_JOB WHERE J.EMPLID = '100166'
  2   AND J.EMPL_STATUS = 'A'
  3   AND J.EFFDT =  (SELECT MAX(J1.EFFDT) FROM PS_JOB J1
  4   WHERE J1.EMPLID = J.EMPLID AND J1.EFFDT <= SYSDATE) AND
  5   J.EFFSEQ = (SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2
  6   WHERE J.EMPLID = J2.EMPLID AND J.EFFDT = J2.EFFDT);
 J.EFFSEQ = (SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2
   *
ERROR at line 5:
ORA-00904: invalid column name

Thanks in advance.