rarbuckle1982

 Profile Answers by rarbuckle1982 

• Aug 4th, 2008

 

It is a shorthand notation.  Easier to use if you have to reference the table over and over.

SELECT * FROM tbl_Long_Table_Name, tbl_Other_Long_Table_Name
WHERE tbl_Long_Table_Name.FieldID=tbl_Other_Long_Table_Name.FieldID
 AND tbl_Long_Table_Name.FieldID=1

Can be done like this:

SELECT * FROM tbl_Long_Table_Name a, tbl_Other_Long_Table_Name b
WHERE a.FieldID = b.FieldID
 AND a.FieldID=1

soujanyaj

 Profile Answers by soujanyaj 

• Aug 5th, 2008

 

The Alias name is used as a shorthand notation for the tble name, for example: if there are 2 tables with long name then it will be difficuilt to call that table hence the alias name is used.

table alias name is also used to remove the ambiguity of the column names used in different tables

Bhuvaneswari.V

 Profile Answers by Bhuvaneswari.V 

• Dec 3rd, 2008

 

Joins Require them if you are using the same table (or view) multiple times. Alias can serve clarify to data source.

docjvk

 Profile Answers by docjvk 

• Dec 6th, 2008

 

Allows table to be used more than once in query, allows shorter qualified name.

goksn

 Profile Answers by goksn 

• Sep 23rd, 2009

 

-is a shorthand notation
-Will be used along with column name if same colum name present in more than one table (while joining those tables)
-Must in self join

psingla

 Profile Answers by psingla Questions by psingla

• Mar 3rd, 2010

 

1. Alias is a alternate name given to a table for multiple purposes.
2. The scope of the Alias is within the query
3. Alias is used to give short name to the table.
4. Used when same table is used n number of times in a query. Alias is used in such queries to give unique name to each table reference.