WHERE Condition problem

[Former Member]

Hello I am trying to do this inner join:

SELECT prps_{pspnr prps}imprf prps_{objnr jest}stat jest~inact

tj02t_{txt04 tj02t}spras

INTO TABLE t_join FROM prps

INNER JOIN jest ON prps_{objnr = jest}objnr

INNER JOIN tj02t ON jest_{stat = tj02t}istat

FOR ALL entries IN t_anla

WHERE prps~pspnr = t_anla-posnr

AND jest~stat LIKE 'I*'

AND jest~inact = inact

AND tj02t~spras = 'P'.

but it returns nothing, unless i comment this condition:

AND jest~stat LIKE 'I*'

There are records starting with I...

Any sugestions?

[Former Member]

Comment out the condition

loop at t_join where field1(1) = 'I'
  append t_join into m_join.
endloop.

reward points if helpful

[prabhu_s2]

instead of

jest~stat LIKE 'I*'

use

jest~stat CP  'I*'

or this can be acheived using ranges also

[Former Member]

hi check this , may be ur order is in correct this is good i think..

SELECT prps~pspnr

prps~imprf

prps~objnr

jest~stat

jest~inact

tj02t~txt04

tj02t~spras

FROM

( ( prps INNER JOIN jest ON prps_{objnr = jest}objnr )

INNER JOIN tj02t ON jest_{stat = tj02t}istat )

INTO TABLE t_join

FOR ALL entries IN t_anla

WHERE prps~pspnr = t_anla-posnr

AND jest~stat LIKE 'I*'

AND jest~inact = inact

AND tj02t~spras = 'P'.

regards,

venkat.

[Former Member]

not use

jest~stat LIKE 'I*'

but

jest~stat LIKE 'I%'

[Former Member]

SELECT prps_{pspnr prps}imprf prps_{objnr jest}stat jest~inact

tj02t_{txt04 tj02t}spras

INTO TABLE t_join FROM prps

INNER JOIN jest ON prps_{objnr = jest}objnr

INNER JOIN tj02t ON jest_{stat = tj02t}istat

FOR ALL entries IN t_anla

WHERE prps~pspnr = t_anla-posnr

AND jest~stat LIKE 'I%' <-- Change here

AND jest~inact = inact

AND tj02t~spras = 'P'.

[Former Member]

jest~stat LIKE 'I*' in place of this just keep

jest~stat CP 'I*'.

EX : I0091

CP : Contains Pattern

OR use offset , this will solve ur problem