Re: Join Table

From: Roland Svensson <roland.svensson_at_localhost.se>
Date: 1998/10/03
Message-ID: <3615dba6.7453998@nntpserver.swip.net>#1/1

On 29 Sep 1998 10:40:27 GMT, paulkcng_at_news.netvigator.com (Ng K C Paul) wrote:

>From the performance point of view, should I use cursor instead of
>joining table to select data?
>

Yes, and not only from the performance point of view. Your task is quite easily solved by two cursors and some matching code. A 'pure' SQL solution performs terrible and is hard to read and understand.

-- 
Regards,
Roland

Received on Sat Oct 03 1998 - 00:00:00 CDT