bleA.Name=tableB.Name;
> +---+--++
> | Name | Age | Salary |
> +---+--++
> | Amit | 27 | 5 |
> | Sumit | 31 | 6 |
> | Anand | 29 | 55000 |
> | Parry | 32 | NULL |
> +---+--++
>
> Regards,
> Ami
ECTED]
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.
>
>regar
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
