Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

SQL join

Photo of author

By Team EasyExamNotes

SQL JOIN

A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins are:

  1. INNER JOIN: Select records that have matching values in both tables.
  2. LEFT JOIN: Select records from the first (left-most) table with matching right table records.
  3. RIGHT JOIN: Select records from the second (right-most) table with matching left table records.
  4. FULL JOIN: Selects all records that match either left or right table records.
 


More topics from DBMS to read:

References:

  1. Korth, Silbertz,Sudarshan, “Fundamental of Database System”, McGraw Hill
  2. Atul Kahate , “ Introduction to Database Management System”, Pearson Educations

Download as PDF

Related posts:

  1. SQL Functions
  2. History of DBMS
  3. Introduction to DBMS
  4. Introduction to Database
  5. Advantages and Disadvantages of DBMS
  6. SQL | DDL, DML, DCL Commands
  7. Domain
  8. Entity and Attribute
  9. Relationship among entities
  10. Attribute
  11. Database Relation
  12. DBMS Keys
  13. Schema
  14. Twelve rules of CODD
  15. Normalization
  16. Functional Dependency
  17. Transaction processing concepts
  18. Schedules
  19. Serializability
  20. OODBMS vs RDBMS
  21. RDBMS
  22. SQL Join
  23. SQL Functions
  24. Trigger
  25. Oracle cursor
  26. Introduction to Concurrency control
  27. Net 11
  28. NET 3
  29. NET 2
  30. GATE, AVG function and join DBMS | Prof. Jayesh Umre
  31. GATE 2014 DBMS FIND Maximum number of Super keys | Prof. Jayesh Umre
  32. GATE 2017 DBMS Query | Prof. Jayesh Umre
  33. Data types
  34. Entity
  35. Check Constraint
  36. Primary and Foreign key
  37. DDLDMLDCL
  38. Database applications
  39. Disadvantages of file system data management
  40. RGPV DBMS Explain the concepts of generalization and aggregation with appropriate examples
  41. RGPV solved Database approach vs Traditional file accessing approach
  42. Find all employees who live in the city where the company for which they work is located
  43. Concept of table spaces, segments, extents and block
  44. Triggers: mutating errors, instead of triggers
  45. Dedicated Server vs Multi-Threaded Server
  46. Distributed database, database links, and snapshot
  47. RDBMS Security
  48. SQL queries for various join types
  49. Cursor management: nested and parameterized cursors
  50. Oracle exception handling mechanism
  51. Stored Procedures and Parameters

Leave a Comment