topic Inner join two tables in Application Development and Automation Discussions

Inner join two tables

Former Member — Thu, 13 Mar 2008 02:19:27 GMT

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

Re: Inner join two tables

Former Member — Thu, 13 Mar 2008 02:55:59 GMT

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

Re: Inner join two tables

Former Member — Thu, 13 Mar 2008 03:13:32 GMT

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

Re: Inner join two tables

ak_upadhyay — Thu, 13 Mar 2008 03:14:19 GMT

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

Re: Inner join two tables

Former Member — Thu, 13 Mar 2008 03:17:40 GMT

Hi Gurus

Thanks for your help , It is working fine now

thread closed

Regards

Re: Inner join two tables

Former Member — Thu, 13 Mar 2008 03:18:10 GMT

Hi Gurus

Thanks for your help , It is working fine now

thread closed

Regards

Re: Inner join two tables

Former Member — Thu, 13 Mar 2008 03:18:31 GMT

Hi Gurus

Thanks for your help , It is working fine now

thread closed

Regards