Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Define and Use Table Alias Names
How To Define and Use Table Alias Names? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement:
SQL> SELECT e.first_name, e.last_name, d.department_name FROM employees e INNER JOIN departments d ON e.department_id=d.department_id; FIRST_NAME LAST_NAME DEPARTMENT_NAME -------------------- -------------------- --------------- Steven King Executive Neena Kochhar Executive Lex De Haan Executive Alexander Hunold IT Bruce Ernst IT David Austin IT Valli Pataballa IT ......
2007-04-19, 5985👍, 0💬
Popular Posts:
How can you check to see whether a symbol is defined? You can use the #ifdef and #ifndef preprocesso...
What is test metrics? Test metrics accomplish in analyzing the current level of maturity in testing ...
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...
What is PMP(project management plan)? The project management plan is a document that describes the p...
How to convert a Unix timestamp to a Win32 FILETIME or SYSTEMTIME? The following function converts a...