Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 What are the types of joins exist in SQL?

Author  Topic 

sherifmkhalil
Starting Member

5 Posts

Posted - 2005-08-03 : 14:03:14
What are the types of joins exist in SQL?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-08-03 : 14:46:55
Inner, outer (left outer, right outer, full outer) and cross.

what types of joins are you looking for?



-ec
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-03 : 14:55:54
quote:
Originally posted by sherifmkhalil

What are the types of joins exist in SQL?



Why'd you post this here when you got the answer on dbforums.com? The list isn't going to change and we have the same sense of humor here too

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-08-03 : 15:16:23
quote:
Originally posted by paulrandal
....and we have the same sense of humor here too



http://www.dbforums.com/t1174672.html

Are you kidding? It is much worse here.....

Hey Paul, I know this joint down the road where we can get a margarita....






Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-08-03 : 15:23:27
quote:
Originally posted by X002548

quote:
Originally posted by paulrandal
....and we have the same sense of humor here too



http://www.dbforums.com/t1174672.html

Are you kidding? It is much worse here.....

Hey Paul, I know this joint down the road where we can get a margarita....

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx



Sorry man, my knees hurt.

Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-08-04 : 08:54:20
That's just wrong.....



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2005-08-04 : 09:29:31
But funny!

Aj

--What happens when social workers and programmers collide:
Social Worker: "They aren't an Identified Resource Family, they are an IR Family."
Me: "What does IR stand for?"
Social Worker: "Identified Resource."
Go to Top of Page
   

- Advertisement -