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:

SELECT * FROM a
LEFT JOIN b ON a.id = b.id
UNION 
SELECT * FROM a
RIGHT JOIN b ON a.id = b.id;