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)