lester@... wrote:

> > 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?
>

It depends on your condition tableA.number = tableB.number.
I assume that SELECT tableB.datefield FROM tableB
where tableA.number = tableB.number)
produces just single value and we need MAX as a pseudo function
to let IB now that we produce a single value.

>
> 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
>
>
> 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/

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7а
E-mail: lev@...