sql - 我正在尝试在 SQL（tera 术语）中创建一个表，但显示的内容与我的预期不同

Question

我认为它应该显示我在下面放置的值（冒险类型）。

标签： sql

Answer 1

create table Service( servicelD varchar(10)CONSTRAINT servicelD_pk PRIMARY KEY NOT NULL, 
actorlD varchar(10) NOT NULL, 
directorlD varchar(10)
NOT NULL, 
title varchar(40), 
console varchar(10), 
genre varchar(15), 
dateRelease date)
insert into Service
values ('S-1011003', 'A-03', '100103-01', 'The Iron Man', 'Blu-ray', 'Adventure', '28-SEP-07') 

create table Actor ( actorlD varchar(10) CONSTRAINT actorlD_pk PRIMARY KEY NOT NULL, actorRole varchar(20)); 
insert into Actor
values ('A-03', 'Supporting Actor') 

select s.servicelD, a.actorlD, s.title, s.genre, a.actorRole  from [service] s 
left join actor a on a.actorlD = s.actorlD
where s.genre = 'Adventure'; 
--
drop table Actor
drop table Service