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!

Table join on one to many relationship but only return one many row

fmountfordSep 23 2011 — edited Sep 23 2011

This ones doing my head in Im sure I know the answer but just cant seem to put it together.

I have 2 tables that I need to join together, with a one to many relationship

But on the many table I only want to return a single result

There is not a way to identify which row i want so it can be any row

Ive tried nested queries, different joins, groups but I cant get it.

I hope someone can help

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2011

Added on Sep 23 2011

5 comments

5,938 views