By 25/02/2016 1 Comments

What Is INNER JOIN Keyword In SQL?

  • The SQL INNER JOIN joins multiple database tables with each other.
  • The SQL INNER JOIN is a keyword which is used to retrieves/selects all records/rows from multiple database tables as long as there is a match between the columns in each tables.
  • The SQL INNER JOIN is also known as simple join and are commonly used.

Syntax:

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;

Example:

SELECT ci.city_name, co.country_name
FROM city AS ci
INNER JOIN country AS co
ON ci.country_id = co.country_id;






← Previous Tutorial


Posted in: Sql

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .