By 08/02/2016 0 Comments

What is SQL JOIN and its types

SQL JOIN:

  • It is a feature which is used in SQL.
  • It is used to retrieve data from multiple database tables.

OR

  • It is used to retrieve data from more than one database tables at a time.
  • Through SQL JOIN we can retrieve data from large numbers of database tables.

Types:

  • INNER JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
  • SELF JOIN

Example:

SELECT gid, first_name, last_name, pid, gardener_id, plant_name 
FROM Gardners
INNER JOIN Plantings
ON gid = gardener_id






Posted in: Solutions

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 .