Re: (SQL) UPDATING a table from a join

From: Emmanuel Baechler <ebaechle_at_hospvd.ch>
Date: Fri, 12 Jun 1998 09:26:57 +0200
Message-ID: <3580D841.6D38_at_hospvd.ch>


Peter H. Larsen wrote:
>
> Hi,
> Try to use EXSIST instead of the IN clause. That should give you almost the
> same speed as a JOIN. (it's known as a SEMI join).

Thanks for this suggestion, it is interesting!

Best regards

Emmanuel Baechler
Lausanne
Switerland Received on Fri Jun 12 1998 - 09:26:57 CEST

Original text of this message