sql vnútorné spojenie
SELECT field1, CASE field2
WHEN condition1 THEN 'result1'
WHEN condition2 THEN 'result2'
ELSE 'result'
END, field3
FROM table_name;
plný syntax vnútorné spojenie
SELECT character.name, inventory.id
FROM charactercreator_character AS character,
charactercreator_character_inventory AS inventory
WHERE character.character_id = inventory.character_id;