How do i write the query for this problem?
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?