How to make a query which use column and table aliases but not using joins
Select
channel_id AS "ClAlias" from tblchannel TbAlias where
tblaias.IS_DEFAULT = 1;
Giving error of invalid identifier, how can I make such a query which uses both table and column
aliases but not related to joins.
My separate table alias
and column aliases queries are working fine:
(Table alias query)
SELECT
CHANNEL_ID, IS_DEFAULT from tblchannel ImTbAlias WHERE ImTbAlias.IS_DEFAULT =
1;
(Column alias query)
Select channel_id "ImClAlias" from tblchannel;
Thanks in advance.
Suthish NairPosted Oct 26, 2010, 6:54 AM
Select channel_id AS "ClAlias" from tblchannel TbAlias where TbAlias.IS_DEFAULT = 1;
Suthish NairPosted Oct 28, 2010, 3:41 PM
If this post helped you, then tick the checkbox above "Do you like this Answer"
Syed Arbab AhmedPosted Oct 27, 2010, 1:47 AM
Syed Arbab AhmedPosted Oct 26, 2010, 5:57 AM
"invalid identifier".
Koteswararao MallisettiPosted Oct 26, 2010, 4:27 AM
select TbAlias.channel_id as "CIAlias" from tablechannel TbAlias where tblaias.IS_Default=1