topic Re: help needed in rewriting the code using inner joins in Application Development and Automation Discussions

help needed in rewriting the code using inner joins

Former Member — Wed, 28 Feb 2007 19:06:08 GMT

Hi all,

I need help in rewriting this code

DATA : FLD LIKE ZTABLE-ZFLD,

FLD1 LIKE ZTABLE2-ZFLD2.

select single ZFLD from zTABLE1 into FLD

where MATNR = '123' and

werks = 'ABC'.

select single ZFLD1 from zTABLE2 into FLD1

where zFLD = FLD.

iS there way that we can write this with inner joins

Thanks

Re: help needed in rewriting the code using inner joins

Former Member — Wed, 28 Feb 2007 19:09:40 GMT

ONLY if there is any common field in both the dtabase tables. like as below

SELECT a_{ZFLB b}ZFLD1 from ZTABLE1 As a

INNER JOIN ZTABLE2 AS b ON a_{FIELDNAME EQ b}FIELDNME.

otherwise he query u have written is correct.

hope this will help

Thanks

Ashwani

Re: help needed in rewriting the code using inner joins

Former Member — Wed, 28 Feb 2007 19:11:18 GMT

Hello,

Do like this


SELECT SINGLE A~ZFLD B~ZFLD1 INTO ( FLD,FLD1) from ZTABLE1 AS A 
INNER JOIN ZTABLE2 AS B on A~FLD EQ B~FLD
WHERE MATNR EQ 123
and         WERKS EQ ABC

If useful reward

Re: help needed in rewriting the code using inner joins

Former Member — Wed, 28 Feb 2007 20:49:37 GMT

Hi,

help me out

TABLE 1 HAS

MATNR , WERKS , FLD1.

TABLE 2 HAS

FLD1, FLD2.

I KNOW MATNR AND WERKS BASED ON THAT I HAVE TO GET FLD2

I WANT IT BE WRITTEN WITH INNEWR JOINS

WITH FOLLOWING COD E I GET AN ERROR MESSAGE SAYING

comma without preccing colon (after select?)

data : FLD1 like zTABLE1-ZFLD1.

data : FLD2 like ZTABLE2-ZFLD2.

SELECT F_{ZFLD1 B}ZFLD2

INTO ( FLD1, FLD2)

FROM ZTABLE1 AS F INNER JOIN ZTABLE2 AS B

ON F_{ZFLD1 = B}FLD2

WHERE F~MATNR = '123'

AND F~WERKS = 'ABC' .

Thanks

Re: help needed in rewriting the code using inner joins

Former Member — Wed, 28 Feb 2007 20:55:07 GMT

Hi,

Please try this.

SELECT F_{ZFLD1 B}ZFLD2

FROM ZTABLE1 AS F INNER JOIN ZTABLE2 AS B

ON F_{ZFLD1 = B}FLD2

WHERE F~MATNR = '123'

AND F~WERKS = 'ABC' .

Regards,

Ferry Lianto

Re: help needed in rewriting the code using inner joins

suresh_datti — Wed, 28 Feb 2007 20:57:54 GMT

use

SELECT F_{ZFLD1 B}ZFLD2

INTO (FLD1, FLD2)

FROM ZTABLE1 AS F INNER JOIN ZTABLE2 AS B

ON F_{ZFLD1 = B}FLD2

WHERE F~MATNR = '123'

AND F~WERKS = 'ABC' .

~Suresh

Re: help needed in rewriting the code using inner joins

Former Member — Wed, 28 Feb 2007 20:58:13 GMT

Hi Deepthi,

You need to give a comma after field by giving a space.

Try with this code.

SELECT F_{ZFLD1 B}ZFLD2

INTO<b> ( FLD1 , FLD2 )</b>

FROM ZTABLE1 AS F INNER JOIN ZTABLE2 AS B

ON F_{ZFLD1 = B}FLD2

WHERE F~MATNR = '123'

AND F~WERKS = 'ABC' .

Thanks,

Vinay