Sql inner join

I want to run the following sql query on the push of a button but I am not sure how to do it with Component Scripting.

update Thermoplastics.dbo.FinishingResults set Thermoplastics.dbo.FinishingResults.BushingContainer = Thermoplastics.dbo.Curelot.BushingsContainer, Thermoplastics.dbo.FinishingResults.AdhesiveContainer = Thermoplastics.dbo.Curelot.AdhesiveContainer, Thermoplastics.dbo.FinishingResults.CureLot = Thermoplastics.dbo.Curelot.CureLot from Thermoplastics.dbo.CureLot inner join Thermoplastics.dbo.FinishingResults on Thermoplastics.dbo.FinishingResults.Container = [Thermoplastics].[dbo].[CureLot].Container

sql = “”“update
Thermoplastics.dbo.FinishingResults
set
Thermoplastics.dbo.FinishingResults.BushingContainer = Thermoplastics.dbo.Curelot.BushingsContainer,
Thermoplastics.dbo.FinishingResults.AdhesiveContainer = Thermoplastics.dbo.Curelot.AdhesiveContainer,
Thermoplastics.dbo.FinishingResults.CureLot = Thermoplastics.dbo.Curelot.CureLot
from
Thermoplastics.dbo.CureLot
inner join
Thermoplastics.dbo.FinishingResults
on
Thermoplastics.dbo.FinishingResults.Container = Thermoplastics.dbo.CureLot.Container”""
system.db.runUpdateQuery(sql)[/code]Note that triple quotes are python’s way of supplying multiline strings.