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]
=================================
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
