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;
Computer Science . Database Management System and Web Application . Developer Underground . Team Malaysia