select query

[Former Member]

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]

use inner join and select required fields

[Former Member]

wht u want here?

[Former Member]

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]

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.