🚀 go-pugleaf

Ok thanks. Pleased to know its not just me and it is difficult to do
(with respect complexity.)

Given this (and as the app is in Delphi) I think I may elect to just
iterate through both tables and update (synchronise) the data
programatically. Seems in many ways easier (although probably not as
efficient.)

Many thanks..

Paul.


On 25 Jun 2007 16:00:51 -0700, "Bill Todd" <no@no.com> wrote:

>I suspect that you have rows in Customers that do not exist in
>Customers_Imported and that you want to update only those rows in
>Customers that have a matching record in Customers_Imported with the
>values from Customers_Imported. If so, something like the following
>(untested) should work.
>
>Yes, it seems unnecessarily complex to have to repeat the subquery for
>each field but that's what you have to do.
>
>UPDATE CUSTOMERS
>SET NAME = (SELECT customers_imported.name
>FROM customers_imported
>WHERE customers.account_ref = customers_imported.account_ref)
>WHERE EXISTS
>  ( SELECT 1
>    FROM customers_imported
>    WHERE customers.account_ref = customers_imported.account_ref);

OS : Windows XP Service Pack 2
Delphi : 2005 Service Pack 3 Installed
CPU : AMD 3500+