Select Most Recent Invoice Price for Customer versus Quote Price
I have two tables I would like to query and compare. I want to find the most recent price a customer has paid and compare it to the most recent price they were quoted for the same item but only returns results if the two prices are different. Below are some mock tables.
SQL Service – Select Most Recent Invoice Price for Customer versus Quote Price
I have two tables I would like to query and compare. I want to find the most recent price a customer has paid and compare it to the most recent price they were quoted for the same item but only returns results if the two prices are different. Below are some mock tables. I am very new to SQL queries (self taught) and can do quick look ups for specific information.