SQL Update with INNER JOIN
Example query:
update [signalling].[dbo].[Lokasi] SET eventLocation = s.qEventLocation FROM [signalling].[dbo].[Lokasi] AS l INNER JOIN [syncdb].[dbo].[stations] AS s ON s.stationname = l.station;
Example query:
update [signalling].[dbo].[Lokasi] SET eventLocation = s.qEventLocation FROM [signalling].[dbo].[Lokasi] AS l INNER JOIN [syncdb].[dbo].[stations] AS s ON s.stationname = l.station;
Ulasan