This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:26 pm, m...@lawinegevaar.nl wrote: No Comment. ==Ticket History== On Mar 07, 2014 @ 03:26 pm, venussof...@gmail.com wrote: 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 ------ This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/111 [Non-text portions of this message have been removed]