Re: Conversion of Update from MSSQL generates "SQL command not properly ended"

This :

---

update table1 set (col1, col2) = (select col1,col2 from tdable2 where recid=table1.recid)
where exists (select 1 from t2 where recid=table1.recid and recid in(1, 2))
---

... should read as:

---

update table1 set (col1, col2) = (select col1,col2 from tdable2 where recid=table1.recid)
where exists (select 1 from table2 where recid=table1.recid and recid in(1, 2))
---

VC Received on Fri Jul 23 2004 - 17:17:03 CDT