SQL Query help
I am new to this forums...
I wanted an help on a query
I have 3 access table
1. Manufacture Table - contains info about manufacturers
2. Products Table - contains info about manufacturers products. An manuf may have more than one product and we use the mfr ID to link the product to the manuf.
3. Category Table - contains info on the categories and their names
* are the fields for the table
The field "newest" in the table "Products" is an integer. Higher the value the newer the product is.
I want an SQL query to get one product per mfr and the product should be the one with the highest newest value.
I would really like some help on the query.