This content has been marked as final. Show 2 replies
please have a look at my example. I must build a comparison between OUT and IN Plants. When there is the same date on a plant OUT in comparison to a plant IN something went wrong.
ID 1 have plant B OUT: 2.2.2015 and plant D IN: 2.2.2015 THIS IS WRONG!
And now I want to have a new table which shows me ID:1; Date: 2.2.2015; Exception: 3
ID 2 have plant U OUT: 2.2.2015 and plant D IN: 5.2.2015 THIS IS CORRECT because they have different dates...
SO how to build such a table like in example 1?
Thank you... !