Brief Idea Needed

[cyrus]

I want to know about inner joins and try my hands on that, Can someone explain in detail about inner join and provide me an example on this so that I could get a brief idea about this concept.

[sreevalliveturi]

In MySQL, CROSS JOIN is a syntactic equivalent to INNER JOIN
In standard SQL, they are not equivalent. INNER JOIN is used with an ON clause, CROSS JOIN is used otherwise.
INNER JOIN and , (comma) are semantically equivalent in the absence of a join condition: both produce a Cartesian product between the specified tables (that is, each and every row in the first table is joined to each and every row in the second table).

If u have any further queries after going thru this u r free 2 ask nytime!

[caradoc]

Using the inner join you can join two tables and get the rows of the two tables which satisfy the given condition given as predicate. One sample of using inner join in update query is given below for you to have a brief understanding on the concept of inner join.
update x
set column1 = y.columnc,
column2 = 'X'
from tablename1 x inner join tablename2 y
on x.columnname = y.columnname