SQL query to Access format -

I have a SQL query that works for my solution in SQL Looking at my current location and software, I am unable to use my Oracle software I am currently traveling and trying to do some extra work.

I have a SQL query:

  SELECT tt.supplierId, products from tt.Price tt INNER JOIN (selection provider ID, MAX (price) AS [Prices] Products Supplier ID by Group) Group TT. SPLIID = Grouped. SPLIID and TT.Price = GroupGrade.Pris  

In Access while trying to run it, I get many errors, from 'Parameter Value Enter', for unavailable expansions. I have not reached a long time and have used 'rusty' on syntax. I have tried several ways to work in Access, like no luck.

Use and in the ON section Between two situations

  ON tt.SupplierID = Groupedtt.SupplierID and tt.price = groupedtt.price  

Use the object to name the field name anytime while trying to reuse the field expression.

If this segment causes an error ...

  SELECT SupplierID, MAX (value) AS value  

... use one instead of both ...

  SELECT SupplierID, MAX (value) In the form of Maxprice SELECT SupplierID, MAX (Price)   

If the entry continues to request a parameter value, please state that it is named as the parameter name What explains in You can find this by running a query from the Access Query Designer - Include the parameter name in the input parameter dialog.