Такое задание:
CREATE TABLE region (
id_reg INT,
name VARCHAR (100) );

CREATE TABLE obl (
id_obl INT,
id_reg INT,
name_obl VARCHAR (50));

CREATE TABLE type_rod (
id_type INT,
type VARCHAR(60));

CREATE TABLE size_rod (
id_size INT,
size VARCHAR (10));

CREATE TABLE rodowushcha (
id_rod INT,
name_rod VARCHAR(40),
id_obl INT,
location VARCHAR(100),
id_type INT,
id_size_oil INT,
id_size_gas INT,
year_open INT,
year_working INT );

ALTER TABLE region ADD PRIMARY KEY (id_reg);
ALTER TABLE obl ADD PRIMARY KEY (id_obl);
ALTER TABLE obl ADD CONSTRAINT cs_obl FOREIGN KEY(id_reg) REFERENCES region (id_reg);
ALTER TABLE type_rod ADD PRIMARY KEY (id_type);
ALTER TABLE size_rod ADD PRIMARY KEY (id_size);
ALTER TABLE rodowushcha ADD PRIMARY KEY (id_rod);
ALTER TABLE rodowushcha ADD CONSTRAINT cs_rodowushcha FOREIGN KEY (id_obl) REFERENCES obl (id_obl);
ALTER TABLE rodowushcha ADD FOREIGN KEY (id_type) REFERENCES type_rod (id_type);
ALTER TABLE rodowushcha ADD FOREIGN KEY (id_size_oil) REFERENCES size_rod (id_size);
ALTER TABLE rodowushcha ADD FOREIGN KEY (id_size_gas) REFERENCES size_rod (id_size);

Хочу сделать вывод полной бд:
select rodowushcha.id_rod,
region.name,
obl.name_obl,
rodowushcha.name_rod,rodowushcha.location,
type_rod.type,
size_rod.size,
size_rod.size,
rodowushcha.year_open,rodowushcha.year_working
from region
inner join obl on region.id=obl.oblast_id
inner join rodowushcha on obl.id=rodowushcha.id_obl
left join type_rod on rodowushcha.id_type=type_rod.id_type
left join size_rod on rodowushcha.id_size_oil=size_rod.id_size
or rodowushcha.id_size_gas=size_rod.id_size
order by id_rod

Проблема, что ПК из таблицы size_rod имеет два ФК в табл родовища и не выводит правильно. Незнаю как обьяснить по сути(

tiroo97,