How to make a query which use column and table aliases but not using joins

arbab · October 26th, 2010, 03:44 AM

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.

Old Pedant · October 26th, 2010, 03:43 PM

The kind of "quote marks" you can use around named depends on what database you are using. And also what the "settings" in that database are.

But for a name such as CIAlias you don't need any marks.

You should be able to just use

Code:

Select channel_id AS ClAlias from tblchannel AS TbAlias where tbAlias.IS_DEFAULT = 1;

You only need "quote marks" around aliases if the aliases are the same as keywords in the DB you are using.

Note: For MySQL, you need to use `...` marks (those are "back ticks"...they are *NOT* apostrophes!). For Access, you need to use [...]. For SQL Server, whether you can use "..." or not depends on a setting in the DB.

arbab · October 27th, 2010, 01:37 AM

Thanks for your elaborate answer.