Challenging.............

[#1]

Hi  Community,

PFA,

Material & Plant as KEY

Here in my table i have status(ok and invalid),

i want to compare with another table, only invalid field status.......

in my 3rd table i have a QTY field

i want to compare with this field (WRP QTY-ORDER QTY)

based on Material & Plant as KEY

Thanks in Advance.......

[#2]

Forgot to create the key while joining. Silly of me