The three types of join are inner join, left join and right join. The inner join option takes the matching values from both the tables by the ON option. The left join selects all the variables from the first table and joins second table to it. The right join selects all the variables of table b first and join the table a to it
You can use ANSI join MERG ans SET
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!