Hi, got 2 tables
Table 1: This conatains just ordernumber, articles and quantity on order
Table 2: This contains article data type, length, hight, wieght and casepack
I want in my script identify all rows from table 1 that not equal to the case pack, let me illustrate:
From table 1:
1.Ordernumber 455, article 12222, quantity 3
2.Ordernumber 455, article 12222, quantity 6
-----------------------------------------------------------------
Table 2 contains
Article 455, Casepack 6
-----------------------------------------------------------------
So now in my script a will mark row 1 with 'ODD' and row 2 with 'EVEN'
Are you with me 🙂
