topic Select with Join in Application Development and Automation Discussions

Select with Join

Former Member — Mon, 09 Apr 2007 13:24:38 GMT

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

a~NOT_EXT_VISIBLE = 'X' and

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.

Re: Select with Join

Former Member — Mon, 09 Apr 2007 13:29:24 GMT

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

Re: Select with Join

former_member632991 — Mon, 09 Apr 2007 13:30:52 GMT

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

*and

where

a~NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

Regards,

Sonika

Re: Select with Join

Former Member — Mon, 09 Apr 2007 13:32:22 GMT

Hi..,

compare it in WHERE clause..

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.

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

regards,

sai ramesh

Re: Select with Join

former_member1195866 — Mon, 09 Apr 2007 13:35:33 GMT

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

Re: Select with Join

Former Member — Mon, 09 Apr 2007 13:35:46 GMT

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 where a_{NOT_EXT_VISIBLE = 'X' and b}tdobject = 'SCMG_CASE' and b~tdspras = sy-langu.

regards,

bharat.

Re: Select with Join

Former Member — Mon, 09 Apr 2007 13:52:54 GMT

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

WHERE

a~NOT_EXT_VISIBLE = 'X' and

b~tdobject = 'SCMG_CASE' and

b~tdspras = sy-langu.

Thanks,

Vinay