update....so I managed to create a CASE statement that worked.

Which accomplishes one of many other tasks I need to accomplish.  I'm realizing a little more and more as I ask...

So I can kind of make out how to read your query and what the syntax

SELECT TOP (10) price, price_facet

FROM Mohawk_Production.dbo.[Mohawk_Prod] AS p

INNER JOIN MAPPING.dbo.[MAPPING_price_FACET] AS f ON p.price <=...

Hi Thanks for the response.  So after searching and searching, I think what I need is to create a CASE SELECT Statement?

Just to be clear, I am not using ACCESS...

🙂 Thanks for the chuckle....let me try and help you put your wheels back on!

I get the first part of your response.  Using a Join rather than a lookup will...

• This reply was modified 4 years, 1 month ago by  MannyR.

Hi, so here are tables and a brief explanation of the end goal without naming tables in sql as I had this working in ACCESS and now hit a wall.....I...

Hi,

Thanks for the tip and I will keep it in mind as it looks easier.  As I said, I'm new and for some odd reason SQL compared to what I...

Tables are all in SQL.

I need to use the JOIN if you have an example of how I showed wrote query that would be great.

Thanks.