sql - MySQL Update Inner Join Aliases - Stack Overflow

You should use Min instead of Least: Update anothertable Join ( Select hotelid, country, to , Min(from_price) ...

stackoverflow.com