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;

Ulasan

Catatan popular daripada blog ini

SISTEM PENGOPERASIAN KOMPUTER (OS)

APA ITU ASCII (AMERICAN STANDARD CODE FOR INFORMATION INTERCHANGE) ?

APA ITU STRUCTURED QUERY LANGUAGE (SQL)