As you said, such syntax is MSSQL specific. AFAIK only MSSQL server and may be SyBase support that.
You have tree options: 1. Update each field in various UPDATE statements: UPDATE spiffy_table st SET st.field1 = (select field1 from other_table where key=st.key) UPDATE spiffy_table st SET st.field2 = (select field2 from other_table where key=st.key) ... 2. Write an SP. 3. Write client application to do that. -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Noah J SILVA Enviado el: Miercoles, 23 de Julio de 2003 02:37 p.m. Para: [EMAIL PROTECTED] Asunto: Silly SQL question! Hi, This is a silly question, not that SAPDB specific I think, but I want to do something like: UPDATE st SET st.field1 = ot.field1, st.field2 = ot.field2 FROM spiffy_table st, other_table ot WHERE st.key=ot.key Only SAPDB doesn't like the FROM clause... (I know, I know.. too much ms-SQL-server...) I am sure this can be done with a subquery, but have had a mental block on exactly how... Any ideas? Thank you, Noah Silva IS&T - Programmer Analyst (215) 419 - 7916 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
