How do i write the query for this problem?

Nov 15 2011 12:56 AM

Hi,

I have the details of a quotation in 1 table and the details of revised quotations in another table. In the dropdownlist i want all the quotations and if there are any revisions made to it(in case a single quotation is revised 3 times), i want the latest revised quotation id. If there are more number of quotations revised many times. How do i get all the latest revised quotation ids?