SQL Type of Joins:

Pubblicato il: 07 luglio 2019
sul canale di: b2aLearning

200

SQL Type of Joins: #Inner Join #Left/Right Join #Outer Join
In this video, we have discussed on the various types of joins.

Join is a clause which is used to combine records of two tables, based on a column that relates both the table.

Inner Join: The result of this type of join is as per the common/matching records from both the tables based on a field/ column that defines the relation between both the tables.

Left /Left Outer Join: Here all the records of left table will be returned along-with the matching records from another table. In case, records are not matched from another table, the fields of another table in the resultset will be 'null'.

Right/Right Outer Join: Here all the records of right table will be returned along-with the matching records from another table. In case, records are not matched from another table, the fields of another table in the resultset will be 'null'.

Full Outer Join: Here all the records will be returned. Its a combination of Left join and right join resultset minus inner join resultset.

Note: Null is undefined and doesnt have any value, thereby 2 nulls cant have same value.

In questa pagina del sito puoi guardare il video online SQL Type of Joins: della durata di ore minuti seconda in buona qualità , che l'utente ha caricato b2aLearning 07 luglio 2019, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 200 volte e gli è piaciuto 6 spettatori. Buona visione!

33,515,265

345K