distinct problem
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)
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)
0