Im very new to writing sql scripts, i wrote the following code in access sql but when i copy it into SQL express 2012 i get an error saying
"Incorrect syntex near the keyword 'LEFT'"
UPDATE dbo_TblMaster LEFT JOIN Tbl_RentalData ON dbo_TblMaster.Serial_Number = Tbl_RentalData.[Asset Serial Number] SET dbo_TblMaster.Current_Status = IIf([Tbl_RentalData].[Asset Serial Number]=[dbo_TblMaster].[Serial_Number],"On Circuit","Off Circuit"), dbo_TblMaster.Supplier_MPID = [Tbl_RentalData].[CustomerReference], dbo_TblMaster.Supplier_Group = [Tbl_RentalData].[Group_Supplier], dbo_TblMaster.Meter_Install_Date = [Tbl_RentalData].[Original Installation Date];