Skip to Content
Former Member
Aug 10, 2007 at 10:44 AM

Joining table



I wanted to know whether we cann add leading zeros in the join condition

or use offset in the join condition.

select a~kunnr


from knvv as inner join zcust

on knvv-kunnr+5(5) = zcust-refid.

will the above statemtnet work?

if not then how do we do it. as the length of knvv-kunnr is 10 and zcust-refid is 5.

i have either add leading zeros or use offset on knvv-kunnr to get the values .

can somebody send me a sample code to do this...

thanks in advance.