Profile Picture
IT Made Easy
The site provides some rough IT Notes that make your life easier. The site currently has notes on HTML, CSS, Regex, OOPS, JS, JQuery, PHP, Java, ASP.NET, C#, Database, Linux, URL Rewrite, SEO, Project Management and Hosting. Please do share this site if you like.

Join

Next
Next

CARTESIAN JOIN is a join of every row of one table to every row of another table.

INNER JOIN (sometimes called the "EQUI-JOIN") is a join that selects only those records from both database tables that have matching values.

OUTER JOIN selects all of the records from one database table and only those records in the second table that have matching values in the joined field. In a left outer join, the selected records will include all of the records in the first database table. In a right outer join, the selected records will include all records of the second database table.

SELF JOIN which is a table joined to itself.

IT Notes

by VinodSebastian



IT Downloads


Catalogue