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 questions and read the responses I get. I must say if you high speed experts can tone it down a tad with newbies so they can build a good foundation with the basics and then get all complex that would be easier to understand for beginners such as myself.
I'm hoping you can add some more knowledge with what I soon realized with SQL tonight after managing to create the CASE statement that provided the result I was looking for. This is perhaps a lack of knowledge on my end, but obviously a query is a query. Unlike ACCESS which I am more familiar with, I realized that while I managed to create my query, it didn't change or add the result to the colunmn that I am trying to populate.
So, I tried adding Update, etc and didn't accomplish much as I am lacking the knowledge to understand SQL and it's obvious I am not thinking in SQL language yet.
What overview can you provide to learn a tad more about how you would run a query and get the results of a particular query value/end result to get appended to the field you want to populate.
The big picture with my project is, I don't want to create several databases that are a 1 to 1 or 1 to many relationship. I have a master table that has all the column and field names for the end result, but in order to get to that end result I have to run queries and what not to add values to fields. I know this is out of the ordinary, but I have a purpose.
So how would I get the result from my CASE statement to populate into a certain field "price_facet", do I change the language of the Case statement or add another query in order to append the desired result or update the value in a particular field?
thanks for any input