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