This gives me the error 'Single row subquery produced more that one
row' - which makes sense.

Any other ideas ?


--- In ib-support@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

> Of the top of my head:
>
> update tableA
> set tableA.datefield = (SELECT tableB.datefield FROM tableB
> where tableA.number = tableB.number)
>
> I could be wrong,
> Set