SQL Language (MOSC)

MOSC Banner

distinct problem

edited Feb 17, 2013 9:01PM in SQL Language (MOSC) 11 commentsAnswered ✓
  Hello every body, I am facing a problem in the following scenario
suppose we have one table

x with the following information
event_id, errormsg    which has 2 rows
1 , 'Acct Number error'
1, ' Currency Error'

I want to link it with the following table y :

event_id, line_num   which has the following data
1, 1
1, 2

the link between the 2 tables is the event_id

I want to retrieve the lines information with its errors but without duplicate

 is there any way to write a sql where I can retrieve only 2 rows
( I am developing a report as following (using oracle report builder)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center