robin thomas
04-11-2007, 06:03 AM
I have 2 tables A and B. A has fields id and quantity. B has fields aid and date. I want to take the value of quantity field from A corresponding to max of date of B joining A.id and B.aid. How can i write query for that. Please help me.