Thanks a lot all of you, Thank u very much. regards anandkl
On 7/22/08, Amit Sharma <[EMAIL PROTECTED]> wrote: > > Example: > > mysql> select * from tableA; > +-------+------+ > | name | age | > +-------+------+ > | Amit | 27 | > | Sumit | 31 | > | Anand | 29 | > | Parry | 32 | > +-------+------+ > > > mysql> select * from tableB; > +-------+--------+ > | name | Salary | > +-------+--------+ > | Amit | 50000 | > | Sumit | 60000 | > | Anand | 55000 | > | Alex | 10000 | > | Ben | 90000 | > +-------+--------+ > > TABLEA RIGHT JOIN TABLEB > mysql> Select tableA.Name, tableA.Age, tableB.Salary from tableA right join > tableB on tableA.Name=tableB.Name; > +-------+------+--------+ > | Name | Age | Salary | > +-------+------+--------+ > | Amit | 27 | 50000 | > | Sumit | 31 | 60000 | > | Anand | 29 | 55000 | > | NULL | NULL | 10000 | > | NULL | NULL | 90000 | > +-------+------+--------+ > > > TABLEA LEFT JOIN TABLEB > mysql> Select tableA.Name, tableA.Age, tableB.Salary from tableA left join > tableB on tableA.Name=tableB.Name; > +-------+------+--------+ > | Name | Age | Salary | > +-------+------+--------+ > | Amit | 27 | 50000 | > | Sumit | 31 | 60000 | > | Anand | 29 | 55000 | > | Parry | 32 | NULL | > +-------+------+--------+ > > Regards, > Amit Sharma @ Affle > > -----Original Message----- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 22, 2008 7:59 PM > To: mysql@lists.mysql.com > Subject: Re: LEFT JOIN and RIGHT JOIN > > At 09:05 AM 7/22/2008, you wrote: > >Hi All, > >Can u please let me know when should i use LEFT JOIN and when should i > going > >for a RIGHT JOIN. Please let me know some examples. > > > >regards > >anandkl > > anandkl, > > Take a look at the tutorial at > http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php > > Mike > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
