Hi,everyone
I have problem in making a query, I need help
In our company's database ,there is a table stored the information of the products that we want to purchase, supplier's price,the date the supplier provide their price...., the data in table is like this:
PRODUCT SUPPLIER PRICE Price-ISSUEDDATE
p01 A 100 01/12/01
p01 A 105 01/01/02
p01 C 99 11/12/01
p02 B 70 02/01/02
p02 B 80 12/11/01
........
now,we want to get every supplier's Latest price for the products, the result of query should like this:
PRODUCT SUPPLIER PRICE Price-ISSUEDDATE
p01 A 105 01/01/02
p01 C 99 11/12/01
p02 B 70 02/01/02
........
I don't know how to make this query,if someone have any idea,Please advise.Thank you for any suggestion and hints
I have problem in making a query, I need help
In our company's database ,there is a table stored the information of the products that we want to purchase, supplier's price,the date the supplier provide their price...., the data in table is like this:
PRODUCT SUPPLIER PRICE Price-ISSUEDDATE
p01 A 100 01/12/01
p01 A 105 01/01/02
p01 C 99 11/12/01
p02 B 70 02/01/02
p02 B 80 12/11/01
........
now,we want to get every supplier's Latest price for the products, the result of query should like this:
PRODUCT SUPPLIER PRICE Price-ISSUEDDATE
p01 A 105 01/01/02
p01 C 99 11/12/01
p02 B 70 02/01/02
........
I don't know how to make this query,if someone have any idea,Please advise.Thank you for any suggestion and hints