please help me

can u give the simple definition's


what is the deference between JOIN & INNER JOIN /OUTER JOIN and LEFT
JOIN /RIGHT JOIN


please help me i filly confused..

On Thu, 06 Mar 2008 09:41:16 -0800, Damodhar wrote:

> please help me
>
> can u give the simple definition's
>
>
> what is the deference between JOIN & INNER JOIN /OUTER JOIN and LEFT
> JOIN /RIGHT JOIN
>
>
> please help me i filly confused..

JOIN and INNER JOIN are the same. They display the rows for the left
table once for each matching row in the right table, and the other way
around.

a LEFT (OUTER) JOIN shows all of the output rows from the INNER JOIN,
plus if any rows from the left table do not have matching records from
the right table, it's added with the rows from the right table replaced
by NULL

a RIGHT (OUTER) JOIN does the same, but adding the extra rows from the
right table only

a (FULL) OUTER JOIN shows the extra rows from both tables.

Hope that helps...


--
Remove caps to reply

On Mar 6, 9:41 am, Damodhar <damu...@gmail.com> wrote:
> please help me
>
> can u give the simple definition's
>
> what is the deference between JOIN & INNER JOIN /OUTER JOIN and LEFT
> JOIN /RIGHT JOIN
>
> please help me i filly confused..

For future reference, please use a more descriptive Subject.

You never know, someone else might be trying to get an answer to the
same question you have.

"Hi" doesn't tell much about the question!

:-)

Thanks

then another one doubt.

whats the different between mysql 4 and mysql 5, give any 4 things
haivng in mysql 5 thats are not present in mysql4

plese help me

Damodhar wrote:
> Thanks
>
> then another one doubt.
>
> whats the different between mysql 4 and mysql 5, give any 4 things
> haivng in mysql 5 thats are not present in mysql4
>
> plese help me

Read the docs like the rest of us did....

http://dev.mysql.com/doc/

hi ,

Thanks For Your help,.

but i want whats the advanced feature are added in mysql5 i cannot
able to get exact what are the features are added in mysql 5 please
help me..


thanks
damu

Damodhar wrote:
> hi ,
>
> Thanks For Your help,.
>
> but i want whats the advanced feature are added in mysql5 i cannot
> able to get exact what are the features are added in mysql 5 please
> help me..
>
>
> thanks
> damu
>

As he said - read the docs. That's what the rest of us have to do.

Want to see what's now? Check the features in 4.1, then compare that
list to the one for 5.0. That's what I did when I was looking for the
changes.

Or look though the change history for each release and see which ones
are new features.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================