Joining tables in Oracle?

How can I perform a LEFT join, INNER join, and a RIGHT join in Oracle 8i please? I've got some MS Access queries I need to convert to Oracles - it seems to be a little limited on the join syntax but I'm sure there's a way around it?

For example, here are 2 queries I need to use with Oracle:

SELECT ig_dictionary.*
FROM ig_keywords
INNER JOIN (ig_dictionary INNER JOIN ig_keydict ON ig_dictionary.dictionary_id = ig_keydict.dictionary_id) ON ig_keywords.keyword_id = ig_keydict.keyword_id WHERE ig_keywords.keyword_id='123456'

SELECT ig_keywords.keyword_id, ig_keywords.keyword, ig_dictionary.dictionary_id, ig_dictionary.title FROM ig_keywords
RIGHT JOIN (ig_dictionary LEFT JOIN ig_keydict ON ig_dictionary.dictionary_id = ig_keydict.dictionary_id) ON ig_keywords.keyword_id = ig_keydict.keyword_id WHERE ig_keywords.keyword_id='123456'

Thanks in advance...
Gary. Received on Tue Dec 26 2000 - 17:36:26 CST