UPDATE SQL Syntax problem.

[MarkButler]

I must admit that I am not familiar with the SQL UPDATE. I use the SQL SELECT for various reports without a problem but I have a need to update a value from one table to another. I tried the following query and am getting
a syntax problem pointing to the "FROM" clause. Any help would be appreciated. Following is the query as I currently have it.

-----
update employer set employer.bondindemnity = emplcust.ins_bond from
employer, emplcust where employer.employer=emplcust.employer
-----

TIA

--

Mark Butler

 

[MarkButler]

The above syntax works in MS SQL. For Pardox is should be a sub query as follows.

---
UPDATE employer SET employer.bondindemnity = (SELECT ins_bond FROM emplcust WHERE emplcust.employer = employer.employer)
---

FYI