🚀 go-pugleaf

This (at first) sounds simple, anad maybe is. However, I am unable to
find any exampleof how to accomplish it. Here is what I am attempting
to do..

1. Two Tables Identical in structure. I would like to use one table to
update all the columns / fields in the other. 
2. Would link tables on key fields account_ref

I have tried this, but fails with the error (from IbConsole) ...
"ISC ERROR CODE:335544652

ISC ERROR MESSAGE:
multiple rows in singleton select"

//=============================================
UPDATE CUSTOMERS
SET NAME = (SELECT customers.name
FROM customers,customers_imported
WHERE customers.account_ref = customers_imported.account_ref)
WHERE EXISTS
  ( SELECT customers.account_ref
    FROM customers,customers_imported
    WHERE customers.account_ref = customers_imported.account_ref);
//=============================================

Even if this works, it seems overly-complicated and would only update
one field. I would like to update all fields while linking them on the
account_ref field(s)

Any help would be much appreciated..

Many thanks..

Paul.

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