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? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries
✍: 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:
mysql> SELECT l.id, l.url, r.comment FROM fyi_links l INNER JOIN fyi_rates r ON l.id = r.id; +-----+-------------------+-----------+ | id | url | comment | +-----+-------------------+-----------+ | 101 | dev.fyicenter.com | The best | | 102 | dba.fyicenter.com | Well done | | 103 | sqa.fyicenter.com | Thumbs up | +-----+-------------------+-----------+ 3 rows in set (0.00 sec)
2007-05-11, 4834👍, 0💬
Popular Posts:
What is difference between SITP and UTP in testing ? UTP (Unit Test Plan) are done at smallest unit ...
What will be printed as the result of the operation below: main() { int x=10, y=15; x = x++; y = ++y...
How to create a thread in a program? You have two ways to do so. First, making your class "extends" ...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
How can I show HTML examples without them being interpreted as part of my document? Within the HTML ...