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

Re: Why won't this work?

I don't think you identified the table first table as J.

Dave Benzenhafer

-----Original Message-----
From: Cliff Scott [mailto:SCOTTC@SENSORMATIC.COM]
Sent: Tuesday, June 05, 2001 5:15 PM
To: SQR-USERS@list.iex.net
Subject: 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.