本文共 280 字,大约阅读时间需要 1 分钟。
连接表语法:
A join B -- A表连接B 表
on
A.m-B.n -- 连接条件
join ......
SELECT film.film_id, film.title FROM film WHERE film_id NOT IN ( SELECT film.film_id FROM film JOIN film_category ON film.film_id=film_category.`film_id` JOIN category ON film_category.`category_id`=category.category_id);
转载地址:http://vnxhn.baihongyu.com/