Updates columns in a columnized table.
Note: In import scripts the update command must be enclosed in brackets {}
Syntax:
UPDATE table_to_update from_alias [LEFT JOIN|INNER JOIN table_to_update_with join_alias]
set amount=amount*100,
somecolumn=join_alias.somecolumn_in_alias
WHERE from_alias.somecolumn is null
{UPDATE Customers SET CustName='Schmitt', City='Hjorring' WHERE CustNumber=2134}
{
UPDATE fInvoiceLines a left join dInvoiceHeaders b on a.Company=b.Company and a.[DocNo]=b.[DocNo]
set wPricesIncludingVAT = b.[Prices Including VAT]
where b.[Prices Including VAT]=1}
}
Comments
Please sign in to leave a comment.