update tableA
set tableA.datefield = (SELECT MAX(tableB.datefield) FROM tableB
where tableA.number = tableB.number)
But it's wrong anyway.

rodbracher wrote:

> 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/