Hi all,
Under "Enter SQL statement" in ST05 when i use the below SQL statement i get a information message " Error received from Explain". It is because of the INNER JOIN iam using. If i remove the INNER JOIN it works fine.
SELECT *
FROM S725
INNER JOIN MARA ON S725MATNR = MARAMATNR
WHERE VRSIO = '000'
AND SPWOC IN (200152, 200153, 200152)
AND WERKS IN (0010, 0020, 0051, 0100, 0111, 0321, 0331, 0341)
AND MATNR IN (000000000000500000, 000000000000500001)
AND MATKL IN (M-01, M-02, M-03)
How can i use INNER JOIN in Explain SQL??
Thanks
Bluesky
