Time is a crucial resource that every company treasures and attempts to convert into a reward. When selecting document management software, pay attention to a clutterless and user-friendly interface that empowers customers. DocHub delivers cutting-edge instruments to maximize your file managing and transforms your PDF file editing into a matter of one click. Replace Cross in the Participation Agreement with DocHub to save a ton of efforts and boost your productiveness.
Make PDF file editing an simple and intuitive process that will save you plenty of valuable time. Quickly modify your documents and send them for signing without turning to third-party alternatives. Concentrate on pertinent duties and increase your file managing with DocHub right now.
now today were going to look at cross apply and outer apply ill explain how they differ from regular joints and why we need them [Music] [Music] apply why do we need it so to start things off lets take a look at a simple query the simple left join so as you can see were just going to join the person table to get their name to the person phone table to get their phone number now were going to use a left join as im sure most of you are familiar with because maybe theyre someone that we have a customer that didnt provide their phone number all right so they may not have a record in this table but we still want to return the names of all our customers anyway so lets go ahead and run this were just going to filter it to for the first 10 customers all right okay and as you can see most customers have a phone number except michael raheem he does not so he does not have a record in the person phone table all right so this just kind of sets the stage um but now lets look at another w
