vrv333

Hi All

I got my answer with below SQL statement. Thanks to everyone

Hi

Using Where Clause is bringing all the materials in E15. But I want materials that are in Plant E15 but not in another plants. Is there any way that i could apply that restriction?

Hello Guys

I am new to SQL and Need your help regarding SQL code to get data from below table.

MATERIAL PLANT

M101 E15

M101 B44

M102 E15M102 B55

M103 E15

M103 B01

M104 E15

M105 E15

M106 E15

M106 B44

M106 B01

My SQL Output should be M104 E15

M105 E15

Basically we want to identify materials that are only exclusive to E15. If the material is in any other plants we don’t want the material in the output.

I appreciate all your help

Thanks