Sql Help!

[randomguy]

which type of join should be used to join 2 tables based on 1 common column
in sql server 2008

[ChampakDas]

inner join but depends on what you want in your output

[karthi647]

buddy am not so sure with SQL... but you can try www.w3schools.com . You will get some basics from it...

[JollyBoy]

maaya 1st job aaa.. yedaina eskochu nuv.. req esko mundu

[JUJUBI_JULABI]

Inner -- matching records
left outer -- includes all records from left
right outer -- same but right


oka column mida nuvvu edina join use cheyochu .. ne req batti use it .... read about joins in sql

[Yuvatha]

[quote name='ShockWave' timestamp='1379356277' post='1304256775']
which type of join should be used to join 2 tables based on 1 common column
in sql server 2008
[/quote]
innerjoin use chesko

[Vinuu]

Please post a little more details about the requirement

[SQLbie]

Inner join

[randomguy]

..

[SwamyRaRa]

Inner join

[mustang302]

using the joins depends on the type of output u want to pop...!!

[randomguy]

Thanks Guys...it worked

[papacha]

[url="http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html"]http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html[/url]