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.
