SELECT
  "model"."name" AS "Model",
  "manufacturer"."name" AS "Manufacturer"
FROM "model", "manufacturer"
WHERE
  "model"."manufacturer" = "manufacturer"."id";
