How do you personally explain the difference between Cross Apply and Cross Join?

Posting as :
works at
You are currently posting as works at

Cross join is between two tables or two sub queries, whereas the cross apply is most commonly used to join a table to the results of a TVF.

Having said that, a cross join is every possible combination from both tables or sub queries, so isn’t really comparable to the cross apply. You would really be comparing an inner join to a cross apply.

In terms of the mechanics, the inner join and cross apply are similar by returning matching rows from both outputs.

like

An apply can supply a single row data or many to already existing data. A join can supply multiple rows and and create new ones depending on if it’s an inner, left, or right. Applies are useful for giving a single row of results sorted by date or ID desc

Related Posts

What would you choose & why?

Post Photo
like

What ever happened to the bio-fuels that were supposed to be the Next Big Thing? You never hear about them anymore

like

what’s your go to Starbucks drink? I usually do a grande blonde roast with toffee and soy. Looking to try something new!

like

Do we need to complete all 13 steps in Infosys launchpad Background process. I have completed only 11 documents ( bank and NSR) is pending.

like

Looking to get a new laptop for work/casual everyday use. I’ve had a mac ever since college and it’s awful for work/excel. Does anyone have any recommendations? Looking for 12-16 GB RAM. Budget is under $1300 thanks!

like

Has anyone else tried Strattera, had success, and a few months later felt like work was a struggle again? Am I imagining it? There are reasons why I should not take stimulants, but I miss that feeling of being a “regular” person at work and so am curious if others have had a similar journey and where you all ended up

like

Hi everyone! I’m an ACD/Art with 12 years of experience. Currently looking for my next gig in New York. Unfortunately, most of the times I apply for a job, I’m somehow “overqualified” 😳 (cont)

like

What is the job security for people on bench in HCS? I have joined HCS almost a month and a half and yet to be assigned to a project. I am worried if it would negatively affect my position in HCS. Kindly help with your answers.

like

Any opinions on Deloitte Digital in London? Trying to decide if I’d like to transfer

like

My daughter had tears streaming down here eyes this morning as she begged me not to go to work. I'm heartbroken. The weekend can't come soon enough.

like

Got a lot of “undeliverable” packages lately on Amazon. Anyone with similar issue?

like

How does a regional firm auditor interested in Deloitte’s forensics practice get their foot in the door?

like

How do I tell a firm I screened with that another firm I screened with is moving forward with full rounds? I would prefer the former firm, even though the latter firm is ranked higher. Thanks for any advice

like

When, if ever, do you add “Esq.” to your name outside of work?

I’m currently in a minor dispute with a company over a credit card overcharge and am wondering if I should have added “Esq.” to my signature in my complaint email lol.

likefunny

I have 2 Cathy pacific business class seats on hold from NY to Vietnam via Hong Kong in December through AA miles. If I need to cancel, will I get my aa miles back even with it being booked on a partner ?

like

How much are you all paying in center based childcare ? Kiddos ages?

like

How to ask a company for counter offer (means how to sentence it correctly)?

I do have multiple offers and want to match the maximum amount with the company that I want to join.

Please share your valuable inputs.

Thank you PwC for sponsoring some of us for the Army 10 miler and sponsoring a portion of the race itself

like

Dobby needs a date in midtown east. No hook up. Civilized date. Suggestions?

like

Any other firms moving towards a regional model (i.e., you have to work in projects in your region)? Im not excited about working in the Midwest

Additional Posts in SQL Server

Hello All, if you had the opportunity to explain SQL in a nut shell, what would you say.

Scenarios would be helpful.

like

I am currently recruiting for DBA’s for both SQL Server and Azure SQL DB. What questions should I be asking?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal