Outer Join in MySQL

[25884]

hi!
i have a query in Oracle SQL and i wanna convert it so it runs on MySQL how do i go about doing it...It has an outer join.
"select a.item_name,a.category_id,a.course_id,a.chapter_id,a.item_id,b.page_id,b.page_url,b.page_next_url from course_chapter_detail a,course_chapter_item_detail b where a.category_id = 1 and a.course_id= 1 and a.chapter_id = 1 and a.category_id =b.category_id(+) and a.course_id =b.course_id(+) and a.chapter_id =b.chapter_id(+) and a.item_id = b.item_id(+) and b.page_prev_url(+) IS NULL"

Where can i get some tutorial that shows how to use joins in MySQL?
Thanks a lot.
Sonali

 

[Firelord84]

Well, I'm not sure if this is what you're looking for, but take a look at

http://www.mysql.com/doc/J/O/JOIN.html

The MySQL documentation is very good. (There search engine is somewhat lackluster, but it does the job)

--Firelord84