mysql - SQL join or union -

i have 1 union query done, issue prints out entire course list database. here statement:

select id, parent, name, 'category' `type` course_categories union select ( 1000 + id ) id, category, fullname, 'fullname' `type` course 

i want join table:

org_courses id orgid courseid

i'm having issues getting correct results , i'm trying keep aliases same in first query because have rendertree function prints these out in nice ul, li, i'm tryng not have rewrite it. in joining these appreciated.

put first 1 in sub-query this:

select * (   select id, parent, name, 'category' `type`   course_categories   union   select ( 1000 + id ) id, category, fullname, 'fullname' `type`   course ) courses inner join org_courses    on org_course.courseid = courses.id