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
- Data Model
- Logical Data Model
- Physical and Relational Data Model
- Data Normalization
- Managing the RDBMS
- Performance Issue
- MS SQL
- URL Rewrite
- Project Management