IT Technical

HKFuey

<div>
That is really helpful thank you!
</div>


<div>
<div class="content wysiwyg-content">
Trying to convert Access syntax to SQL (Update Query)<br />
<br />
UPDATE dbo.tbl_DriveSalesSidhilMa<wbr />trix<br />
Set tbl_DriveSalesSidhilMatrix<wbr />.EnteredBy<wbr /> = case when OperatorName is null then Operator else OperatorName<br />
From dbo.view_Z_SalesOrderAmmen<wbr />dmentsSums<wbr /> INNER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dbo.tbl_DriveSalesSidhilMa<wbr />trix ON dbo.view_Z_SalesOrderAmmen<wbr />dmentsSums<wbr />.Operator = dbo.tbl_DriveSalesSidhilMa<wbr />trix.Enter<wbr />edBy LEFT OUTER JOIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dbo.tbl_Syspro_Operators ON dbo.view_Z_SalesOrderAmmen<wbr />dmentsSums<wbr />.Operator = dbo.tbl_Syspro_Operators.O<wbr />peratorCod<wbr />e<br />
WHERE (dbo.tbl_DriveSalesSidhilM<wbr />atrix.Reco<wbr />rdSource = N'Sidhil')<br />
<br />
I'm getting &quot;Incorrect syntax near the keyword 'From'.&quot;<br />
<br />
Can anyone help?
</div>
</div>


Trying to convert Access syntax to SQL (Update Query)

UPDATE dbo.tbl_DriveSalesSidhilMatrix
Set tbl_DriveSalesSidhilMatrix.EnteredBy = case when OperatorName is null then Operator else OperatorName
From dbo.view_Z_SalesOrderAmmendmentsSums INNER JOIN
                         dbo.tbl_DriveSalesSidhilMatrix ON dbo.view_Z_SalesOrderAmmendmentsSums.Operator = dbo.tbl_DriveSalesSidhilMatrix.EnteredBy LEFT OUTER JOIN
                         dbo.tbl_Syspro_Operators ON dbo.view_Z_SalesOrderAmmendmentsSums.Operator = dbo.tbl_Syspro_Operators.OperatorCode
WHERE (dbo.tbl_DriveSalesSidhilMatrix.RecordSource = N'Sidhil')

I'm getting "Incorrect syntax near the keyword 'From'."

Can anyone help?

Access to SQL Syntax (Update query)

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.