MySQL results sort order question : (tricky)

[listenmirndt]

---

TABLE#1 (LISTINGS)

LISTINGNAME = Freds Dock Shop
PACKAGE_ID = 1

LISTINGNAME = Bettys Dock Shop

PACKAGE_ID = 2

TABLE#2 (PACKAGES)

ID = 1
PACKAGE_NAME = Basic
RANK = 1

ID = 2
PACKAGE_NAME = Premium

RANK = 2

So, I want to query the LISTINGS table & order results by the RANK field (ASC so RANK 1 would show first) found in the PACKAGES table... Sort of a reverse lookup dealy... I'm not too sure how to pull this off, any ideas would be great.

Thanks
-Arron

[NogDog]

SELECT listings.listing_name FROM listings
INNER JOIN packages ON listings.package_id = packages.id
ORDER BY packages.rank ASC

[listenmirndt]

Thank you!
I will give it a try.