Hi,
The following is the query that I used;
select distinct rate ,eff_rcbl_tier_level from TRADE where eff_rcbl_tier_level='D' group by eff_rcbl_table_id
The result the query returned:
rate eff_rcbl_tier_level
------------------ -------------------
0.0000000 D
0.0000000 X
223.6000000 X
Please note that it is returning rows with 'X' when th e where clause specifies a 'D'.
Can someone throw some light on this?
Thanks in advance.
Hope it helps. Let me know what happens.
With regards,
PGK
The following is the query that I used;
select distinct rate ,eff_rcbl_tier_level from TRADE where eff_rcbl_tier_level='D' group by eff_rcbl_table_id
The result the query returned:
rate eff_rcbl_tier_level
------------------ -------------------
0.0000000 D
0.0000000 X
223.6000000 X
Please note that it is returning rows with 'X' when th e where clause specifies a 'D'.
Can someone throw some light on this?
Thanks in advance.
Hope it helps. Let me know what happens.
With regards,
PGK