HELP!: SQL statements

[Mission01]

Hi there....
I'm still new to SQL statements, anyone mind telling me WHAT does INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN to a bunch of tables?... sorry if i've ask a dumb question... but i'm really lousy at SQL statements...:confused:
Thankz!~ I'll really appreciate your help in this...

[Stu]

INNER JOIN means that any rows that do not have a match on the supplied columns are discarded.

OUTER JOIN means that all the rows will be returned, whether there is a match or not.

LEFT JOIN means that the rows in the table on the left of the statement will be returned, whether there is a match or not with the table on the right--if there is no match NULLs will be returned where the data for the table on the right would be.

RIGHT JOIN means that the rows in the table on the right of the statement will be returned, whether there is a match or not with the table on the left--if there is no match NULLs will be returned where the data for the table on the left would be.