Re: Why won't this work?

[Jim Vanderpool <Jim.Vanderpool@CUSYS.EDU>]

You didn't put the alias 'J' after PS_JOB.


At 06:15 PM 06/05/2001 -0400, you wrote:
>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.