in table(ZBOX) records are like this
field1 field2 field3 field4
523012 FGD100 FGD500 BOTTLE
523012 FGD501 FGD800 BOX
Now in selection parameters i am giving FGD200, Based on this value how to get the record(1st record) from Ztable(ZBOX).
please tell me how to write the select query regarding this.
Thanks in advance.