Re: SQL: Update from multiple tables

Hi,

I have the same problem:

UPDATE T1, T2
SET T1.Field2 = T2.Field2
WHERE T1.Field1 = T2.Field1
AND T1.Field3 = T2.Field3

For my ablosute surprize I IT WORKS on dBaseIII driver of ODBC !!!!!!!

I use this for a few years on my systems and now I'm upgrading to new DataDase and I don't find any documentation why it works.

Can someone help me !!!

--
Posted via http://dbforums.com