I am trying to build a query which will give me unique rows. Details:-
Table 2 (F3,F4 are the columns)
My Query (Incorrect)
This gives me below output which is not what I am looking for:-
Expected output that I am building query for is:-
Please let me know if you have any suggestions.
Code:
Table 1 (F1, F2 are the columns) F1 F2 1 A1 2 A2 3 A3 4 A4
Code:
F3 F4 1 B1 1 B11 2 B2 2 B22
Code:
select rrn(A), F1,F2,F3,F4 from rush2hem1.T1 A left outer join rush2hem1.T2 B on A.F1=B.F3
Code:
RRN F1 F2 F3 F4 1 1 A1 1 B1 1 1 A1 1 B11 2 2 A2 2 B2 2 2 A2 2 B22 3 3 A3 (null) (null) 4 4 A4 (null) (null)
Expected output that I am building query for is:-
Code:
RRN F1 F2 F3 F4 1 1 A1 1 B1 2 2 A2 2 B2 3 3 A3 (null) (null) 4 4 A4 (null) (null)
Comment