CREATE TABLE "KalWinOdsTab"(
"Id" VARCHAR(5), 
"Nazwa" VARCHAR(30) COLLATE "PLK",
CONSTRAINT "PK_KALWINODSTAB" PRIMARY KEY ("Id"),
CONSTRAINT "UC_KALWINODSTAB_NAME" UNIQUE ("Nazwa")
);

CREATE TABLE "KalWinOds"(
"Id" VARCHAR(5),
"Od_dnia" DATE DEFAULT CURRENT_DATE,
"Procent" DECIMAL(10, 3) DEFAULT 0.00,
"Skala" SMALLINT DEFAULT 365,
CONSTRAINT "PK_KALWINODS" PRIMARY KEY ("Id","Od_dnia"),
CONSTRAINT "FK_KALWINODS_KALWINODSTAB_ID" FOREIGN KEY ("Id") REFERENCES "KALWINODSTAB" ("Id")
);

SELECT * FROM KalWinOds
WHERE Id = (SELECT Id FROM KalWinOdsTab WHERE Nazwa = 'Test')
ORDER BY Id, Od_dnia;