How to get items with all of its revisions with maximum generation
Hi, I am trying to get part all revision with maximum generation using IOM: below are the entries: Item Number Generation Revision Testnumber1 1 00 Testnumber1 2 00 Testnumber1 3 00 Testnumber1 4 00 Testnumber1 5 00 Testnumber1 6 00 Testnumber1 7 00 Testnumber1 8 01 Testnumber1 9 01 Testnumber1 10 02 so from above entries I want: Item Number Generation Revision Testnumber1 7 00 Testnumber1 9 01 Testnumber1 10 02 I got this result with below SQL: select item_number, MAX(generation) as generation, major_rev from innovator.PART group by item_number, major_rev order by generation but how to do this with IOM? Regards, Maddy.