Select querry using inner join

[Former Member]

Hi Friends,

I need to fetch data from two tables, I used inner join but I am not able to fetch the data in some fields can any one tell me what is wrong in this select querry.

SELECT but000~partner

but000~name_org1

but000~name_first

but000~name_last

but000~bpext

FROM but000 INNER JOIN dfkkop ON but000_{partner = dfkkop}gpart

INTO table lt_but000

WHERE but000~partner IN so_part

AND dfkkop~faedn IN so_faedn.

Thanx in advance,

Parvez

[Former Member]

SELECT but000~partner

but000~name_org1

but000~name_first

but000~name_last

but000~bpext

FROM but000 INNER JOIN dfkkop ON but000_{partner = dfkkop}gpart

INTO CORRESPONDING FIELDS OF table lt_but000

WHERE but000~partner IN so_part

AND dfkkop~faedn IN so_faedn.

TRY TO USE CORRESPONDING FIELDS OF AND CHECK WHETHER IT IS COMING CORRECTLY OR NOT.

REGARDS

SHIBA DUTTA

[Former Member]

hi Lutin,

SELECT but000~partner

but000~name_org1

but000~name_first

but000~name_last

but000~bpext

FROM but000 INNER JOIN dfkkop ON but000_{partner = dfkkop}gpart <------check this condition,it has to *satisfy both table

INTO table lt_but000

WHERE but000~partner IN so_part

AND dfkkop~faedn IN so_faedn.

Regards,

siva

Message was edited by:

SivaKumar

[Former Member]

Hi,

When you are not selecting any field from table dfkkop why do you want to join that table in the select query?

Decide which fields you want and then write the select query with or without join.

Regards

Subramanian

[Former Member]

Hi Line ,

If you are able to retrieve data from some feilds that means that your query is correct , so please check the decleration of your internal table and the sequence is same as the one in your select query.

Regards

Arun

[Former Member]

Hi,

SELECT but000~partner
but000~name_org1
but000~name_first
but000~name_last
but000~bpext
INTO table lt_but000
FROM but000 INNER JOIN dfkkop 
    ON but000~partner = dfkkop~gpart 
WHERE but000~partner IN so_part
     AND dfkkop~faedn    IN so_faedn.

If u dont want dfkkop
SELECT partner
name_org1
name_first
name_last
bpext
INTO table lt_but000
FROM but000 
WHERE partner IN so_part.

This should work, check whether there are entries in the table.

[Former Member]

hi,

Try using CORRESPONDING FIELDS statement and include all the key fields in where condition ..

SELECT but000~partner
but000~name_org1
but000~name_first
but000~name_last
but000~bpext
FROM but000 INNER JOIN dfkkop ON but000~partner = dfkkop~gpart
<b>INTO CORRESPONDING FIELDS OF</b> table lt_but000
WHERE but000~partner IN so_part
AND dfkkop~faedn IN so_faedn.

Regards,

santosh

[Former Member]

Hi..

check the fields in table.whether it contains data or not??also check the where condition (both fileds Domain should be same).

Regards,

Shobha Henry