Page 181 - IT-802_class_12
P. 181

Syntax:

            SELECT table1.column1,table1.column2,table2.column1,....
            FROm table1
            FULL JOiN table2

            ON table1.matching_column = table2.matching_column;
            WHERE,
            table1: First table.
            table2: Second table
            matching_column: Column common to both the tables.
            Example:

            SELECT Student.NAmE,StudentCourse.COURSE_iD
            FROm Student
            FULL JOiN StudentCourse
            ON StudentCourse.ROLL_NO = Student.ROLL_NO;




                Recap Zone

              Ð Ð Data is a collection of raw facts and figures, that is processed to produce meaningful information.
              Ð Ð A database is an assembled group of data that enables easy and efficient storage, access, modification, and retrieval of data,
                regardless of the amount of data being manipulated.
              Ð Ð A database management system is a software package that controls the creation, maintenance and use of a database.
              Ð Ð RDBMS is a relational DBMS in which tables are linked to each other by fields.
              Ð Ð Constraints, are restrictions on the values, stored in a database based on the requirements.
              Ð Ð SQL is a high-level interactive language that allows users to specify what is required to be done in the form of queries.
              Ð Ð MySQL is one of the most popular database management system (DBMS) used for managing relational databases.
              Ð Ð The CREATE TABLE command is used to create a table in SQL.
              Ð Ð DESCRIBE or DESC command is used to describe the structure of a table.
              Ð Ð In Structured Query Language, the ALTER TABLE statement allows you to add, modify, and delete columns from an existing
                table.
              Ð Ð UPDATE command is used to modify the existing records in a table.
              Ð Ð A join clause is used to join two or more table rows based on the associated columns between them.
              Ð Ð The INNER JOIN keyword selects all rows from both the tables as long as the condition is satisfied.
              Ð Ð Left join returns all the rows of the table on the left side of the join and matches rows for the table on the right side of the join.
              Ð Ð FULL JOIN creates the result set by combining the results of both LEFT JOIN and RIGHT JOIN.



















                                                                                 Database Concepts—RDBMS Tool   179
   176   177   178   179   180   181   182   183   184   185   186