|
>>In above data you see part no has 10 revision where few revision has 1, 2 alternative and 1 alternative has preferred 1 & 2 alternative has preferred 0 so i want a query which check preferred only 0 how can i get this.
Well, I know YOU know what that means, cos you wrote it, but it makes no sense to me. Please split it into simple facts, for example:
In above data you see part no has 10 revision where:
few revision has 1, 2 alternative,
1 alternative has preferred 1;
2 alternative has preferred 0
- or whatever it's meant to be.
>>i want a query which check preferred only 0
Again that doesn't make a lot of sense. Can you give the output you want to see from the query, for example should it be:
PART_NO REVISION ALTERNATIVE PREFERRED
11000162 4 2 0
11000162 5 2 0
11000162 6 2 0
11000162 7 2 0
11000162 8 2 0
11000162 9 2 0
11000162 10 2 0
or something else?
|