/* Aliasing a table */

/* Do not use "As" for table aliasing in Oracle */
/* you can still use "AS" for column aliasing   */

SELECT s.lname,   s.fname,   c.course_id
FROM   student AS s,  class AS c				/* table alias MySql */
WHERE  s.ssn  =  c.stu_ssn;


SELECT s.lname  lastname,   c.course_id AS course		/* column alias   */
FROM   student s,  class c					/* AS is optional */
WHERE  s.ssn  =  c.stu_ssn;