Hi all

I know a qty. for a particular item purchased. This item though has been purchased over a long period only the last few purchase bills are now of concern (FIFO method). I have the following tables

tPurchaseBill
iID PK
iNo Bill No.
etc.

sPurchaseBillItems
iID PK
iPID FK to tPurchaseBill table
iItemID FK to mItems table
bQty qty. in this purchase
etc.

so if I am to provide an iItemID and a bStock qty. can I bring out only those last few tPurchaseBill records. Is there any way I can do this in pure SQL?

Please advise

Thanks and regards
Bhavbhuti