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