Skip to Content
0
Former Member
Jan 03, 2008 at 06:02 AM

Inner JOin

23 Views

Hi All

I have a statement using Inner Joins which compares WERKS of S012 and WERKS of S026 as mentioned below.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE IT_S012

FROM ( S012 AS E

INNER JOIN S026 AS F ON FWERKS = EWERKS ).

Now i also want to compare the MATNR of S012 and MATNR of S026.How can i do it.Please Help.

Vijay