SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

left outer join on aggregate function

750523Sep 20 2010 — edited May 8 2012

I was just wondering if anyone knows how to perform a left outer join on a aggregate function? For example, " left outer join A.assignment_id = (select max(B.assignment_id)" I am trying to join both of these columns where B.assignment_id contains the max id for that column. Is there any way to do this in oracle?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2012

Added on Sep 20 2010

6 comments

3,977 views