How many types of join do we have?

[QASA25]

Hi all. could any one explain to me how many types of join we have ? I be happy if some one explain these types to me as i am new to sql server 2000 world.Thanks

 

[PHV]

Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[r937]

that's a great article, phv, but it only covers cross joins, inner joins, and left/right outer joins

missing is any mention of full outer join, which is not surprising, since mysql doesn't support it



r937.com | rudy.ca

 

[PHV]

Anyway, QASA25 should post in one of the sql server fora ...

 

[QASA25]

Thank u guys for you reply. PHV the first link that u posted to me . does it apply to sql server 2000 as well? or it is for mysql only?Thanks

 

[r937]

as far as it goes, yes, that article can be applied to sql server 2000 as well as mysql

r937.com | rudy.ca