SQL

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:

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.

Links

• W3Schools SQL Quick Reference
• DevGuru T-SQL