Hi,
I've an output from a query like given below. I've to again manipulate the result to get another output.
I've to compare the values in the first field with a column in another table,Table2.
But the question is, I've to compare from the 4th position of the cl_id.
Ex: I should check this value '228100-674700' against the column 'Col1' in 'table2' and if it is equal,
get the value from column,'Col2', of that table. If it is not equal leave it as it is.
Can you pls help me out in this ?
Query Output:
--------------
cl_id post_date
-----------------------------------
44-228100-674700 10/31/2003
44-228100-674700 05/31/2003
44-228100-674700 06/30/2003
44-228100-674700 07/31/2003
44-228100-674700 08/31/2003
44-228100-674700 09/30/2003
44-228100-674700 10/31/2003
44-228100-674700 11/30/2003
Table2
--------
Col1 Col2
---------------------
228100-674700 674700C1
I've an output from a query like given below. I've to again manipulate the result to get another output.
I've to compare the values in the first field with a column in another table,Table2.
But the question is, I've to compare from the 4th position of the cl_id.
Ex: I should check this value '228100-674700' against the column 'Col1' in 'table2' and if it is equal,
get the value from column,'Col2', of that table. If it is not equal leave it as it is.
Can you pls help me out in this ?
Query Output:
--------------
cl_id post_date
-----------------------------------
44-228100-674700 10/31/2003
44-228100-674700 05/31/2003
44-228100-674700 06/30/2003
44-228100-674700 07/31/2003
44-228100-674700 08/31/2003
44-228100-674700 09/30/2003
44-228100-674700 10/31/2003
44-228100-674700 11/30/2003
Table2
--------
Col1 Col2
---------------------
228100-674700 674700C1