outer join and inner join

pradeepjain

Hii guys,
I might be silly to ask this ques..but seriously i did not understand the outer join and inner join in mysql site.i understood left and right join also.
can some one explain outer and inner join with some basic definition and example plzz..and also unique key.

thanks,
Pradeep

Atli

Hi.

Check out NeoPa's SQL JOINs article in the Access HowTo section.

Even tho it is written for Access, the principles are pretty much the same.

Note, however, that the OUTER JOIN he describes does not work in MySQL.
To simulate that, you could try something like:

Expand|Select|Wrap|Line Numbers

 
SELECT * FROM a

LEFT JOIN b ON a.id = b.id

UNION 

SELECT * FROM a

RIGHT JOIN b ON a.id = b.id;

outer join and inner join

re: outer join and inner join

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about