Need data from table but there is multiple conditions [message #628488] |
Tue, 25 November 2014 12:01 |
|
deepak416
Messages: 63 Registered: January 2013 Location: Pune
|
Member |
|
|
id name qty mqty branch
1 PEN 3 21 A
1 PEN 4 21 B
1 PEN 13 21 C
2 PENCIL 2 3 A
2 PENCIL 1 3 B
2 PENCIL 1 3 C
There is two type of stock one is PEN and another is PENCIL with qty and min qty, the stock in differ differ branch, i need those row which has less quantity from its minimum qty.
Take an example: There is one stock PEN which has 20 qty but min qty is 21 and PENCIL has 4 qty but its min qty is 3 i need this row in result.
|
|
|
|
Re: Need data from table but there is multiple conditions [message #628491 is a reply to message #628489] |
Tue, 25 November 2014 12:06 |
|
deepak416
Messages: 63 Registered: January 2013 Location: Pune
|
Member |
|
|
id############name##########qty#########mqty#######branch
1*************PEN*********** 3**********21*********A
1*************PEN************4**********21*********B
1*************[/b]PEN[/b]**********13*********21*********C
2*************PENCIL*********2**********3**********A
2*************PENCIL*********1**********3**********B
2*************PENCIL*********1**********3**********C
There is two type of stock one is PEN and another is PENCIL with qty and min qty, the stock in differ differ branch, i need those row which has less quantity from its minimum qty.
Take an example: There is one stock PEN which has 20 qty but min qty is 21 and PENCIL has 4 qty but its min qty is 3 i need this row in result.
[Updated on: Tue, 25 November 2014 12:12] Report message to a moderator
|
|
|
|
|
|
|
|