I have two tables (with sample data):
tblZone
[ZoneNo] [Zone]
-----1------Zone1
-----2------Zone2
-----3------Zone3
tblPointsClient
[PolygonID] [Zone Name]
-----0------------Zone1
-----0------------Zone1
-----0------------Zone1
-----0------------Zone2
-----0------------Zone2
-----0------------Zone2
-----0------------Zone3
-----0------------Zone3
-----0------------Zone3
基本上,使用MySQL,我正在尝试通过tblZone中的ZoneNo更新tblPointsClient中的PolygonID(如果这有意义)。
因此,当我运行此更新时,它应该将PolygonID更改为:
[PolygonID] [Zone Name]
-----1------------Zone1
-----1------------Zone1
-----1------------Zone1
-----2------------Zone2
-----2------------Zone2
-----2------------Zone2
-----3------------Zone3
-----3------------Zone3
-----3------------Zone3
我尝试过以下操作:
UPDATE tblPointsClient
SET tblPointsClient.PolygonID = (
SELECT ZoneNo FROM tblZones WHERE tblPointsClient.ZoneNo = tblZones.Zone
)
但是这使得所有的多边形ID都变成了0
如果有人能帮忙,那将不胜感激!:)