Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 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
stevenryals is an unknown quantity at this point
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!!
stevenryals is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 10:21 AM.


Advertisement
Log in to turn off these ads.