Inner join two tables

[Former Member]

Hi Gurus

I want to do inner join between two tables to extract customer name

kna1.kunnr and kna1.name1

SELECT FKDAT, PKUNAG, NAME1, VRKME, FKIMG, WERKS

FROM S903,KNA1 INNER JOIN KNA1

ON S903.PKUNAG = KNA1.KUNNR

WHERE (S903.WERKS = 'CO01').

"GROUP BY wg4.S903.FKDAT, wg4.S903.PKUNAG, wg4.KNA1.NAME1, wg4.S903.VRKME, wg4.S903.FKIMG, wg4.S903.WERKS.

So how can I join s903 with kna1

regards

pz

[Former Member]

Hi,

Try the below query

SELECT FKDAT, PKUNAG, NAME1, VRKME, FKIMG, WERKS
FROM S903 INNER JOIN KNA1 ON S903.PKUNAG = KNA1.KUNNR
WHERE S903.WERKS = 'CO01'.
"GROUP BY S903.FKDAT, S903.PKUNAG, KNA1.NAME1, S903.VRKME, S903.FKIMG, S903.WERKS.

Regards,

Chandru

[Former Member]

hi,

check the condition . i can not found your table and what is co01 .

SELECT i_{FKDAT i}PKUNAG i_{VRKME i}FKIMG i_{WERKS m}NAME1 into CORRESPONDING FIELDS OF table it

from s903 as i

inner join kna1 as m on i_{werks = m}werks and i~werks in ( 'co01' ).

if it works pls give me rewards point.

Regards ,

pankaj

[ak_upadhyay]

Hi,

Check this one

SELECT FKDAT PKUNAG NAME1 VRKME FKIMG WERKS

FROM S903 INNER JOIN KNA1 ON S903_{PKUNAG = KNA1}KUNNR

WHERE S903~WERKS = 'CO01'.

R/points if helpfull.

Regards

AK

[Former Member]

Hi Gurus

Thanks for your help , It is working fine now

thread closed

Regards

PE

[Former Member]

Hi Gurus

Thanks for your help , It is working fine now

thread closed

Regards

PE

[Former Member]

Hi Gurus

Thanks for your help , It is working fine now

thread closed

Regards

PE