G
Guest
I have a table with say 3 fields: Orders, Items and Charge as follows:
Order Items Charge
1 A 2
1 B 3
1 C 2.5
2 A 2
2 B 3
3 D 2
3 E 2
3 F 2
4...
......
I have to find orders which have charge equal to a given value say 2 for
all items in that order (an example of such an order would be order 3 in the
above table). How can I write a query for this?
Order Items Charge
1 A 2
1 B 3
1 C 2.5
2 A 2
2 B 3
3 D 2
3 E 2
3 F 2
4...
......
I have to find orders which have charge equal to a given value say 2 for
all items in that order (an example of such an order would be order 3 in the
above table). How can I write a query for this?