topic Re: Joining table in Application Development and Automation Discussions

Joining table

Former Member — Fri, 10 Aug 2007 10:44:03 GMT

Hi,

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

or use offset in the join condition.

select a~kunnr

a~vkorg

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.

Former Member — Fri, 10 Aug 2007 10:46:21 GMT

Simply use UNPACK statement

pls don't forget to reward

S@meer

Former Member — Fri, 10 Aug 2007 10:50:39 GMT

hi sameer,

thanks for the reply but how do i use the upack statement in the join.

could send me a sample code of doing this in join.

varma_narayana — Fri, 10 Aug 2007 11:01:46 GMT

hi..

You can use offset in the SELECT statement in this case.

select a~kunnr

a~vkorg

from knvv as inner join zcust

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

This will work.

<b>Reward if Helpful</b>