topic Re: Select querry using inner join in Application Development and Automation Discussions

Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:12:36 GMT

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

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:15:16 GMT

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

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:16:26 GMT

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

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:18:06 GMT

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

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:18:23 GMT

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

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:19:26 GMT

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.

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 08:19:30 GMT

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

Re: Select querry using inner join

Former Member — Mon, 29 Jan 2007 09:01:10 GMT

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