我需要在屏幕上调用请求的内容,但是如何调用呢?我有三个表,其中包含电影的名称,其中包含演员的名称,关系表中包含要正确显示的"id"。但我遇到了这个,很难解决,这里是表格…
To create Actors table
create table tb_ator(
id_ator NUMBER (4) PRIMARY KEY NOT NULL,
nome_ator VARCHAR (50) NOT NULL
);
To Create Films table
create table tb_filme(
id_filme NUMBER (4) PRIMARY KEY NOT NULL,
nome_filme VARCHAR (50) NOT NULL
);
And finaly, the relational
create table ator_filme(
id_filme NUMBER (4) references tb_filme(id_filme),
id_ator NUMBER (4) references tb_ator(id_ator)
);
如何用内连接解决这个问题?
SELECT F.nome_filme, COUNT(AF.id_ator) AS actors
FROM ator_filme AF INNER JOIN tb_ator A ON AF.id_ator = A.id_ator
INNER JOIN tb_filme F ON AF.id_filme = F.id_filme
GROUP BY F.nome_filme;