Tag: What is an ALIAS command?

ALIAS name can be given to a table or column. This alias name can be referred to in WHERE clause to identify the table or column.

Example

Select st.StudentID, Ex.The result from a student st, Exam as Ex where st.studentID = Ex. StudentID

Here, st refers to alias name for student table and Ex refers to alias name for exam table.