At 09:12 AM 2/25/2002 +0530, you wrote: >This should work: > >SELECT requestID, OrderNum, SalesName FROM tHWRequestApprover a >where >OrderNum = ( select max(b.OrderNum) from tHWRequestApprover b where >b.requestID= a.requestIDgroup by b.requestID)
Thanks vibha, It works!! Cheers, /NS =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
