Select with Join

[Former Member]

Please tell me how i should correct this:

select a_{tdid b}tdtext

into corresponding fields of table i_text

from scmgtextid as a

inner join ttxit as b

on a_{tdid = b}tdid and

<b> a~NOT_EXT_VISIBLE = 'X' and</b>

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

The error is:

You cannot compare with "'X'". Each comparison in the ON condition must contain a field from the RH table.

Thanks.

[Former Member]

Hi,

where condition is missing.

select a_{tdid b}tdtext

into corresponding fields of table i_text

from scmgtextid as a

inner join ttxit as b

on a_{tdid = b}tdid where

a~NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

reward if useful

regards,

ANJI

Message was edited by:

Anji Reddy Vangala

[former_member632991]

Hi,

instead of on use where

select a_{tdid b}tdtext

into corresponding fields of table i_text

from scmgtextid as a

inner join ttxit as b

on a_{tdid = b}tdid

*<b>and</b>

<b>where</b>

a~NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

Regards,

Sonika

[Former Member]

Hi..,

compare it in WHERE clause..

<b>select a_{tdid b}tdtext

into corresponding fields of table i_text

from scmgtextid as a

inner join ttxit as b

on a_{tdid = b}tdid

where NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.</b>

<u>** IN 'ON' clause u can compare onli the table fields which are included in JOIN..</u>

regards,

sai ramesh

[former_member1195866]

hey kiret,

Please try

select a_{tdid b}tdtext

into corresponding fields of table i_text

from scmgtextid as a

inner join ttxit as b

on ( a_{tdid = b}tdid )

where a~NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

you should not use and after the join condition, instead use the where condition.

Please reward points if the answer provides any help.

Regards,

Neha

[Former Member]

hi,

select a_{tdid b}tdtext into corresponding fields of table i_text from scmgtextid as a

inner join ttxit as b on a_{tdid = b}tdid <b>where</b> a_{NOT_EXT_VISIBLE = 'X' and b}tdobject = 'SCMG_CASE' and b~tdspras = sy-langu.

regards,

bharat.

[Former Member]

Hi Kiret,

When you use ON clause on Joins the the left hand and right hand fields should be of tables used in Join condition but not with variables/constant values.

Use the rest of the part in WHERE condition.

Check this code.

select a_{tdid b}tdtext

into corresponding fields of table i_text

from scmgtextid as a

inner join ttxit as b

on a_{tdid = b}tdid

<b>WHERE</b>

a~NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

Thanks,

Vinay