Sql Joins

[Swami]

[quote name='cherlapalli_jailer' timestamp='1372811996' post='1303913579']
nee email id pm cheyyi

oka PDF vundi istanu

or goto PDF thread u may find one
[/quote]
[email protected]

[cherlapalli_jailer]

[quote name='Swami' timestamp='1372812040' post='1303913580']
[email protected]

[/quote]
done

[Swami]

[quote name='cherlapalli_jailer' timestamp='1372812137' post='1303913585']
done
[/quote]

mana laptop lo sql ela vesukovali cheppu brother na laptop 500gig and 4 gb ram i will practice

[cherlapalli_jailer]

[quote name='Swami' timestamp='1372812297' post='1303913587']

mana laptop lo sql ela vesukovali cheppu brother na laptop 500gig and 4 gb ram i will practice
[/quote]

oracle or mySql

net lo search ....based on 32 or 64

u will get exe....install it very simple

[Swami]

[quote name='cherlapalli_jailer' timestamp='1372812365' post='1303913589']
oracle or mySql

net lo search ....based on 32 or 64

u will get exe....install it very simple
[/quote]
mysql

[pinky123]

[quote name='Swami' timestamp='1372811934' post='1303913576']
nice
left outer join
right outer join
kuda examples ivu sami
[/quote]

Left Outer Join ante matched records + left side unna table lo anni records vastay

Table A Table B

1 A 1 Apple
2 B 2 Monkey
3 C 7 Cat
4 D 6 DOG

Result:

1 A Apple
2 B Monkey
3 C Null
4 D Null


Right Outer Join ante matched records + right side unna table lo anni records vastay

Table A Table B

1 A 1 Apple
2 B 2 Monkey
3 C 7 Cat
4 D 6 DOG

Result:

1 A Apple
2 B Monkey
7 Null Cat
6 Null Dog

[cherlapalli_jailer]

[quote name='Swami' timestamp='1372812406' post='1303913590']
mysql
[/quote]
very simple to install

and also install heidiSQL( is the client to connect to mySql)

[Swami]

[quote name='cherlapalli_jailer' timestamp='1372812572' post='1303913594']
very simple to install

and also install heidiSQL( is the client to connect to mySql)
[/quote]
yeah sare.. serch chestunna install cheyadaniki

[cherlapalli_jailer]

@pinky123 GP
along with result
also post SQL stmt which helps even better

[SQLbie]

[princeofheaven]

simple explanation:

[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]

[cherlapalli_jailer]

[quote name='princeofheaven' timestamp='1372813224' post='1303913607']
simple explanation:

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

[Swami]

[quote name='princeofheaven' timestamp='1372813224' post='1303913607']
simple explanation:

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