Update on multiple tables
IACONE Roberto <[email protected]> Tue, 16 Sep 2003 12:39:06 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <599E9E92165FD41187C400508BD700DC02FA3D59@traq2.aquila.transcomeurope.com> |
Hi
we aim to migrate our databases to SAP from M$ SQL 7.0, but before we are
testing the different features.
We have issues about updates on a table using the values coming from columns
of another one.
This update statement works on SQL 7.0 but not on SAP.
---------------------------
UPDATE A
SET A.AgenteDiZona = L.Agente+' ('+L.SettoreZona+')'
FROM (AnagraficheTemp A INNER JOIN ListaAgenti L ON A.CAP = L.CAP)
---------------------
Could you please give us a tip or trick?
Regards
=================================
Roberto Iacone
IT Systems Administrator
TRANSCOM WORLDWIDE - L'AQUILA (ITALY)
The Right ANSwer for COMmunication
Phone: +39 862 347 8126
Mobile: +39 348 5507434
Web:www.transcom-worldwide.com
Mail:[email protected]
=================================