subject:"How to update MySQL table based on 3 other tables"

Re: How to update MySQL table based on 3 other tables

2013-09-03 Thread shawn green

Hello Neil, On 8/24/2013 5:21 AM, Neil Tompkins wrote: I have the following four MySQL tables Region RegionId City CityId RegionId Hotel HotelId CityId HotelRegion HotelId RegionId I'm struggling to write a UPDATE statement to update the City table's RegionId field from data in the HotelReg

How to update MySQL table based on 3 other tables

2013-08-24 Thread Neil Tompkins

I have the following four MySQL tables Region RegionId City CityId RegionId Hotel HotelId CityId HotelRegion HotelId RegionId I'm struggling to write a UPDATE statement to update the City table's RegionId field from data in the HotelRegion table. Basically how can I update the City table with