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