Join Types There are two basic types of joins, inner and outer. A query using an inner join will give a result set containing only those rows from both tables which had matching values in the fields on which the tables were joined. That is, records in either table that have no matching value in the other table will Not be included in the result set. Another way to say it, they will not be part of the answer. The other type of join is the outer join.
Outer joins have two sub types, right and left.
This happens whether we are using a database or a third-generation language. Inner Join Finding a third generation language example of an inner join is difficult. Let's take the case in which we have two personnel files. The first file contains certain general information and the second has a record of classes. We need a report with information from both files.