i am able to get the result but the problem is it is case sensitive, i want a
case insensitive
manoj marathayil <[EMAIL PROTECTED]> wrote: i have two tables like this;
CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar
(256), arglist varchar(256), type integer, primary key ( dbname, object_name,
arglist ) );
CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar
(256), arglist varchar(256), type integer, primary key ( dbname, object_name,
arglist ) );
then i issued a query like this;
select * from ((select distinct(tablename), type from objects where dbname =
't_test' union select object_name as 'a', type from sp_objects where dbname =
't_test') as t) order by 2 asc;
this is working as i expected but if i use "order by 1 asc" its not working,
how
can i solve this, thanks in adv...
---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
T h a n k s & R e g a r d s ,
Manoj M | Webyog | Bangalore | Voice: 91 9886171984, 91 80 51216434(off)
"A winner is not one who never fails, but one who never quits!"
---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
