I am trying to build a query which will give me unique rows. Details:-
Code:
Table 1	(F1, F2 are the columns)
F1	F2
1	A1
2	A2
3	A3
4	A4
Table 2 (F3,F4 are the columns)
Code:
F3	F4
1	B1
1	B11
2	B2
2	B22
My Query (Incorrect)
Code:
select rrn(A), F1,F2,F3,F4 from rush2hem1.T1 A left outer join rush2hem1.T2 B on A.F1=B.F3
This gives me below output which is not...