SQL: Unterschied zwischen den Versionen
Aus Claudio's Wiki
(→Links) |
|||
Zeile 1: | Zeile 1: | ||
+ | |||
+ | == SQL-Keywords == | ||
+ | === SQL INNER JOIN === | ||
+ | |||
+ | The INNER JOIN keyword return rows when there is at least one match in both tables. | ||
+ | <pre> | ||
+ | SQL INNER JOIN SyntaxSELECT column_name(s) | ||
+ | FROM table_name1 | ||
+ | INNER JOIN table_name2 | ||
+ | ON table_name1.column_name=table_name2.column_name | ||
+ | </pre> | ||
+ | |||
+ | PS: INNER JOIN is the same as JOIN. | ||
+ | |||
+ | |||
== Links == | == Links == | ||
* [http://www.w3schools.com/sql/sql_quickref.asp W3Schools SQL Quick Reference] | * [http://www.w3schools.com/sql/sql_quickref.asp W3Schools SQL Quick Reference] | ||
* [http://www.devguru.com/technologies/t-sql/home.asp DevGuru T-SQL] | * [http://www.devguru.com/technologies/t-sql/home.asp DevGuru T-SQL] |
Version vom 7. Januar 2009, 10:42 Uhr
SQL-Keywords
SQL INNER JOIN
The INNER JOIN keyword return rows when there is at least one match in both tables.
SQL INNER JOIN SyntaxSELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name
PS: INNER JOIN is the same as JOIN.