SQL: Unterschied zwischen den Versionen

Aktuelle Version vom 7. Januar 2009, 10:43 Uhr

The INNER JOIN keyword return rows when there is at least one match in both tables.

SQL INNER JOIN Syntax:

SELECT 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.

@@ 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.
+SQL INNER JOIN Syntax:
+<pre>
+SELECT 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 ==
-* [http://www.w3schools.com/sql/sql_quickref.asp]
+* [http://www.w3schools.com/sql/sql_quickref.asp W3Schools SQL Quick Reference]
+* [http://www.devguru.com/technologies/t-sql/home.asp DevGuru T-SQL]