I have 2 tables, tbl1 and tbl2, in first table i have following field:
Emp_code Emp_name Basic Hra Convnc. other
tble2 have the same fields, now I have an Emp_code in tbl2 and want to fetch all related values from tbl1 for that emp_code , how can I do this using join ??
thanks in advane.
Thanks Narayan but it gives wrong result...
in the below list we have only 8 unique values but both formulas return result 18...
111
103
111
104
110
105
110
105
111
113
105
115
113
102
107
112
109
120
117
104
120
100
106
108
101
103
120
105
108
114
101