Yet another MySQL join question! :P

[eluser]darkhouse[/eluser]
I think what you want is a UNION. Try this:

Code:

SELECT AdID, CityID, OrderSequence FROM ad_listing
UNION
SELECT AdID, CityID, OrderSequence FROM ad_listing_cities
WHERE CityID = 484 AND Active = 1
GROUP BY AdID
ORDER BY OrderSequence