Need to rapidly join data in exhibit? We've got you covered! With DocHub, you can do just what you need without downloading and installing any software program. Use our solution on your mobile phone, desktop, or web browser to edit exhibit anytime and at any place. Our powerful platform offers basic and advanced editing, annotating, and safety measures suitable for individuals and small businesses. Additionally, we provide numerous tutorials and guides that help you master its capabilities rapidly. Here's one of them!
We provide a range of security options to protect your sensitive data while you join data in exhibit, so you can feel assured of your work’s confidentiality. Get your documents edited, signed, and delivered with a professional, industry-compliant platform. Take advantage of the comfort of getting the job done instantly with DocHub!
all right welcome back so remember in the previous lesson we talked about what happened if there are no matches when joining two tables well lets look at this animation again so as you can see we want to join these two tables and then patrick is going to be joined with climbing and code and because there are two rows that are matched you simply have two of the patricks all right so now maria gets paired with star darwin gets paired with apples so what about albert elizabeth and rugby well these actually just get discarded so this is actually an inner join which is the same thing as join because by default join is an inner join well talk about that more later but what if you want to keep them like albert elizabeth and rugby even if there are no matches and one reason you would want to keep them is if you want to count how many things these users like like for example uh patrick likes climbing and coding so thats two things mario likes stars thats one thing and darwin likes apples w
