题目描述
film表
CREATE TABLE IF NOT EXISTS film (
film_id smallint(5) NOT NULL DEFAULT '0',
title varchar(255) NOT NULL,
description text,
PRIMARY KEY (film_id));
category表
CREATE TABLE category (
category_id tinyint(3) NOT NULL ,
name varchar(25) NOT NULL, `last_update` timestamp,
PRIMARY KEY ( category_id ));
film_category表
CREATE TABLE film_category (
film_id smallint(5) NOT NULL,
category_id tinyint(3) NOT NULL, `last_update` timestamp);
使用join查询方式找出没有分类的电影id以及名称
解答:
用left join,不满足on条件会为null,所以这里select中不能为fc.film_id,因为不满足条件会为null
select f.film_id,f.title
from film f left join film_category fc on f.film_id=fc.film_id
where fc.film_id is null