Skip to content

Join

IT Notes → Database → SQL @ December 22, 2020

  • 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.

Related Posts

  1. SQL ( IT Notes → Database → SQL )
  2. Create Table ( IT Notes → Database → SQL )
  3. Import Data ( IT Notes → Database → SQL )
  4. Select ( IT Notes → Database → SQL )
  5. Update ( IT Notes → Database → SQL )
  6. Delete ( IT Notes → Database → SQL )
  7. Create ( IT Notes → Database → SQL )
  8. View ( IT Notes → Database → SQL )
  9. General ( IT Notes → Database )
  10. RDBMS ( IT Notes → Database )
  11. Data Model ( IT Notes → Database )
  12. Logical Data Model ( IT Notes → Database )
  13. Physical and Relational Data Model ( IT Notes → Database )
  14. Data Normalization ( IT Notes → Database )
  15. Managing the RDBMS ( IT Notes → Database )
  16. Security ( IT Notes → Database )
  17. Performance Issue ( IT Notes → Database )
  18. Insert ( IT Notes → SQL )
  19. Programming ( IT Notes → Database )
  20. MS SQL ( IT Notes → Database )
  21. Introduction ( IT Notes → Database → Oracle )
  22. Data Definition Language ( IT Notes → Database → Oracle )
  23. Data Manipulation Language ( IT Notes → Database → Oracle )
  24. Data Control Language ( IT Notes → Database → Oracle )
  25. Transaction Control Language ( IT Notes → Database → Oracle )
  26. Miscellaneous ( IT Notes → Database → Oracle )
  27. Abbreviations ( IT Notes → Abbreviations )
  28. OOP Concepts or Object Oriented Programming Concepts ( IT Notes → Object Oriented Programming )
  29. Basics ( IT Notes → Javascript )
  30. Regex ( IT Notes → Javascript )
  31. Functions ( IT Notes → Javascript )
  32. General ( IT Notes → Javascript )
  33. Debugging ( IT Notes → Javascript )
  34. Data Types ( IT Notes → PHP )
  35. Operators ( IT Notes → PHP )
  36. Design Pattern ( IT Notes → PHP )
  37. Security ( IT Notes → PHP )
  38. Streams and Network Programming ( IT Notes → PHP )
  39. Arrays ( IT Notes → C# )
  40. Namespace ( IT Notes → C# )
  41. Indexers ( IT Notes → C# )
  42. Generics ( IT Notes → C# )
  43. Attributes ( IT Notes → C# )
  44. Anonymous Types ( IT Notes → C# )
  45. Performance Thumb Rules ( IT Notes → C# )
  46. Different Types of Testing ( IT Notes → Testing )
  47. SAS 70 Type II Audit – Data Security ( IT Notes → Testing )
  48. Tracking Defects ( IT Notes → Testing )
  49. General ( IT Notes → SEO )
  50. IT Notes ( IT Notes )
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x