phil_hhn wrote:

>Thanks, but maybe I simplified my problem too much ;-)
>The column in tableB actually has a different name, and there are
>other columns (and a PK with generator/trigger) on tableB.
>So the above statement does not work...
>
>
>

And if you put the other values in the column list of the select ???

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br