grocery-manager/sqlpage/sqlpage/data/units.sql

DROP TABLE IF EXISTS sqlpage_units;
CREATE TABLE IF NOT EXISTS sqlpage_units AS
SELECT u.name, ut.name AS type FROM units u
JOIN unit_types ut ON ut.id = u.unit_type_id
;