The main reason is
both the tables will be having nearly 4 lakhs and 3 lakhs records.
If we use sub query, he is telling that the execution time will be
more..

Sivaraman

--- In ib-support@yahoogroups.com, Daniel Rail <daniel@a...> wrote:
> Hi,
>
> At April 16, 2003, 11:52, sivram_mail wrote:
>
> > As Daniel said,
> > i can use the Exists also.But my dba is telling that don't use
> > subqueries.
> > Can i get the desired output without subquery???
>
> What is the exact reason that your dba doesn't want you to use
> sub-queries?
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)