oracle查询语句中给表和列起别名

和mysql有点区别：

简而言之就是oracle使用别名时，如果对表用别名，去掉as这个关键字

举例：

oracle:SELECT   ms.user_id_ AS user_id_,ms.group_id_ AS gorup_id_  FROM act_id_user u ,act_id_group g ,act_id_membership ms WHERE ms.user_id_=u.id_ AND ms.group_id_=g.id_ AND u.id_='sjb' AND u.pwd_=123 AND g.id_='gly';

mysql:

SELECT   ms.user_id_ AS user_id_,ms.group_id_ AS gorup_id_  FROM act_id_user AS u ,act_id_group AS g ,act_id_membership AS ms WHERE ms.user_id_=u.id_ AND ms.group_id_=g.id_ AND u.id_='sjb' AND u.pwd_=123 AND g.id_='gly';

参考博客：

http://blog.csdn.net/u012934325/article/details/53139548