topic Re: WHERE Condition problem in Application Development and Automation Discussions

WHERE Condition problem

Former Member — Tue, 11 Mar 2008 10:43:03 GMT

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?

Re: WHERE Condition problem

Former Member — Tue, 11 Mar 2008 10:49:40 GMT

Comment out the condition


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

reward points if helpful

Re: WHERE Condition problem

prabhu_s2 — Tue, 11 Mar 2008 10:53:43 GMT

instead of


jest~stat LIKE 'I*'

use


jest~stat CP  'I*'

or this can be acheived using ranges also

Re: WHERE Condition problem

Former Member — Tue, 11 Mar 2008 10:59:43 GMT

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.

Re: WHERE Condition problem

Former Member — Tue, 11 Mar 2008 11:11:10 GMT

not use

jest~stat LIKE 'I*'

but

jest~stat LIKE 'I%'

Re: WHERE Condition problem

Former Member — Tue, 11 Mar 2008 11:18:15 GMT

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'.

Re: WHERE Condition problem

Former Member — Tue, 11 Mar 2008 11:32:57 GMT

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