|
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!!
|