Have you tried something like this?
Select <whatever cols you need>
from vinitem a
join caselabl b on substr(a.icitem,1,7)=b.itmbas
Seems to me that the output of the select can't be used as the join
criteria. (After all, the fields output by the select are DETERMINED by
the join criteria!) therefore, you need to repeat the substr()
expression in the join clause.
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact