Skilltree

CREATE VIEW [dbo].[SkillTreeResource]

AS

SELECT Job.id as [job_id], [skill_id], [random_id], [min_skill_lv], [max_skill_lv], [lv], [job_lv], [jp_ratio], [need_skill_id_1], [need_skill_lv_1], [need_skill_id_2], [need_skill_lv_2],
       [need_skill_id_3], [need_skill_lv_3], [cenhance_min], [cenhance_max]

FROM SkillTree, Job WHERE SkillTree.job_id = Job.job_id

UNION

SELECT Pet.id as [job_id], [skill_id], [random_id], [min_skill_lv], [max_skill_lv], [lv], [job_lv], [jp_ratio], [need_skill_id_1], [need_skill_lv_1], [need_skill_id_2], [need_skill_lv_2],
       [need_skill_id_3], [need_skill_lv_3], [cenhance_min], [cenhance_max]

FROM SkillTree, Pet WHERE SkillTree.job_id = Pet.job_id

UNION

SELECT Summon.id as [job_id], [skill_id], [random_id], [min_skill_lv], [max_skill_lv], [lv], [job_lv], [jp_ratio], [need_skill_id_1], [need_skill_lv_1], [need_skill_id_2], [need_skill_lv_2],
       [need_skill_id_3], [need_skill_lv_3], [cenhance_min], [cenhance_max]

FROM SkillTree, Summon
WHERE
(
    SkillTree.job_id = Summon.skill1_id OR
    SkillTree.job_id = Summon.skill2_id OR
    SkillTree.job_id = Summon.skill3_id OR
    SkillTree.job_id = Summon.skill4_id OR
    SkillTree.job_id = Summon.skill5_id
)