Subject Re: Update query using multiple tables
Author Adam
--- In, Rich Pinder <rpinder@...> wrote:
> Thanks Adam. Works GREAT !!
> The data from this update is coming in from an external source; after
> the loading, the RICHSELECT table is dropped. (so I wont offend
> Codd&Date !)

OK, that is fine.

Just be aware that tables get internal numbers when they are created,
and these are not reused when dropped. The numbers are finite (IIRC
32K). I am not sure whether external tables also have this restriction.