topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Tue, 08 Jan 2008 09:18:44 GMT

Hi,

I have 3 tables CRMM_BUT_SET0140,CRMM_BUT_LNK0141,

BUT000.

CRMM_BUT_SET0140 has SET_GUID and DSITRICT fields.

CRMM_BUT_LNK0141 has PARTNER_GUID

Former Member — Tue, 08 Jan 2008 09:20:55 GMT

use inner join and select required fields

Former Member — Tue, 08 Jan 2008 09:23:42 GMT

wht u want here?

Former Member — Tue, 08 Jan 2008 09:51:29 GMT

Hi,

sorry..

I have 3 tables CRMM_BUT_SET0140,CRMM_BUT_LNK0141,

BUT000.

CRMM_BUT_SET0140 has SET_GUID and DSITRICT fields.

CRMM_BUT_LNK0141 has PARTNER_GUID and SET_GUID fields.

BUT000 has PARTNER_GUID and PARTNER fields.

I need to extract PARTNER AND DISTRICT fields..

Regards,

Sai

Former Member — Tue, 08 Jan 2008 09:57:58 GMT

hi sai,

This sample code might help u out..

Inner joins using 3 tables

Try this ( example) :-

SELECT stpo_{stlnr stpo}idnrk mast_{matnr mara}mtart stpo~menge

INTO CORRESPONDING FIELDS OF TABLE zmat1 FROM mast

JOIN stpo ON stpo_{stlnr = mast}stlnr

JOIN mara ON mara_{matnr = mast}matnr

WHERE stpo_{stlty = 'M' "AND stpo}idnrk IN s_matnr

AND mast~werks = 1000.

Thankyou,

Regards.