CodingForums.com - View Single Post

stevenryals · 11-29-2012, 06:04 PM

SWEET!! Thanks Old pendant..

I made a new page.. to just display the best results for each tag.. using this query (that has a similar structure to yours)

SELECT tag, url, price, miles, cpm, leg1, departuredate, leg2, arrivaldate FROM expedia MP where price = (SELECT MIN(price) from expedia WHERE tag = MP.tag) ORDER by price;

and it works beautifully..
thanks for all of your help.. I think i understand the basics of aliases now.. that's a needed skill for sure!!

11-29-2012, 06:04 PM	PM User \| #31
stevenryals New Coder Join Date: Jul 2012 Posts: 60 Thanks: 4 Thanked 0 Times in 0 Posts	SWEET!! Thanks Old pendant.. I made a new page.. to just display the best results for each tag.. using this query (that has a similar structure to yours) SELECT tag, url, price, miles, cpm, leg1, departuredate, leg2, arrivaldate FROM expedia MP where price = (SELECT MIN(price) from expedia WHERE tag = MP.tag) ORDER by price; and it works beautifully.. thanks for all of your help.. I think i understand the basics of aliases now.. that's a needed skill for sure!!