Major difference between cross join and inner join

Question

Major difference between cross join and inner join

cooljagadeesh

SSC Eights!

Points: 959
More actions
December 4, 2012 at 10:16 pm

#393741

Hi All,
Can any one explain Wat is the main difference between cross apply and inner join???
according to my view
both are functionality wise same syntax wise different

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jeetsingh.cs SSCommitted Points: 1761 More actions · Answer 1

While most queries which employ CROSS APPLY can be rewritten using an INNER JOIN, CROSS APPLY can yield better execution plan and better performance, since it can limit the set being joined yet before the join occurs.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

cooljagadeesh (12/4/2012)
according to my view
both are functionality wise same

can you explain it ?

And for reading http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Cross join or cross apply? A cross join produces a cartesian products whereas a cross apply applies the values of a result set to a table-valued function.

Using Cross Joins

Using APPLY

Joie Andrew
"Since 1982"

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

cooljagadeesh (12/4/2012)
Hi All,
Can any one explain Wat is the main difference between cross apply and inner join???
according to my view
both are functionality wise same syntax wise different

They can be completely different. CROSS APPLY doesn't have to reference a table, in which case it's most valuable as a row-level calculator. Read the article by Paul White, linked in my sig.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden