Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 31 to 31 of 31
11-29-2012, 06:04 PM #31
- Join Date
- Jul 2012
- 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!!