I have 2 tabels. One with the transactions in a period and the ohter table is a MASTER FILE with the StockNo. I would like to write a script that will show me only the last transaction date for each StockNo. My tabels are:
ReceivingDate (format is YYYYMMDD; for today it will be "20110919")
Could someone tell me what the best approach will be for this case?