Someone
public text v1 · immutableSELECT Id,
(SELECT name,crystal_type FROM armor) UNION (SELECT name,crystal_type FROM weapon)
FROM item_grade2
LEFT JOIN armor ON armor.item_id=item_grade.Id
LEFT JOIN weapon ON weapon.item_id=item_grade.IdSELECT Id,
(SELECT name,crystal_type FROM armor) UNION (SELECT name,crystal_type FROM weapon)
FROM item_grade2
LEFT JOIN armor ON armor.item_id=item_grade.Id
LEFT JOIN weapon ON weapon.item_id=item_grade.Id