> This gives me the error 'Single row subquery produced more that one
> row' - which makes sense.
>
> Any other ideas ?

If it gives multiple tableB.datefield entries which do you
want?

MAX(tableB.datefield) for the last date?

> > update tableA
> > set tableA.datefield = (SELECT tableB.datefield FROM tableB
> > where tableA.number = tableB.number)

update tableA
set tableA.datefield = (SELECT MAX(tableB.datefield) FROM
tableB
where tableA.number = tableB.number)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services