On Nov 5, 2008, at 8:42 AM, Hemant Patel wrote:
> Hello Everyone,
>
> I have a array of ids from my search result and now
> I want to fetch the details from the database.
> Now IN query is ruined my sort order.So should I go for Union All?
IN doesn't ruin your sort order really.... You need to think in sets...
> Is there any other method to fetch the data..?
Can't you not directly join against you other table to fetch the
result directly??
Show us the SQL you are working with + tables would help aswell.
>
> Please help me in this….
> Thanks in advance…
>
> With Regards,
> Hemant Patel
>