Dynamic internal tables

[Former Member]

Dear All,

The problem I am stuck in is that -

---

> I have two internal tables

IT1 with two fields table1 (say, MARA) and field1 (say, MATNR)

and IT2 with two fields table2 (say, MARC) and field2 (say, MATNR)

Now, I want to match whether Field1 = Field2.

Now the Select query , probably using inner join needs to fetch data

but I am confused how shall I write the Select query.

Plz help.................

[Former Member]

Dear All,

The problem I am stuck in is that -

---

> I have two internal tables

IT1 with two fields table1 (say, MARA) and field1 (say, MATNR)

and IT2 with two fields table2 (say, MARC) and field2 (say, MATNR)

Now, I want to match whether Field1 = Field2.

Now the Select query , probably using inner join needs to fetch data

but I am confused how shall I write the Select query.

Plz help.................

[Former Member]

SELECT mara~matnr

FROM mara

INNER JOIN marc

ON marc_{matnr = mara}matnr

WHERE..

Sudha