Whether you deal with paperwork day-to-day or only occasionally need them, DocHub is here to assist you take full advantage of your document-based projects. This tool can join data in Product Evaluation, facilitate user collaboration and create fillable forms and legally-binding eSignatures. And even better, every record is kept safe with the highest safety standards.
With DocHub, you can access these features from any place and using any platform.
inner join full outer left anti-right ante left outer right outer even a self join well see all these join kinds in the merge feature [Music] now weve already used the merge feature in this class to do a classic lookup from a sales table into a product table to get a price and we used left outer join but in this video we want to see the other amazing join kinds now when you do a merge you have two tables and through a related field product in our case we specify a join kind to deliver a merged result now when we do left outer this is a classic lookup into the right table were looking up products into the right table to deliver the price now left outer with this Venn diagram you can see its all from the left but only matching from the right thats why kangaroo thats on the left it has no matching record here but because its on the left we have to list it Majestic Butte from the right table there is no match so we dont show it in the resulting table now you can think of a left out
