我有两个表时间表和主题,我需要从主题表中的id,subject_name,这是没有在时间表中使用的具体章节。
时刻表

主题表

但它返回了多个值,如下图所示。

我正在使用这个查询
SELECT subject.id, subject.subject_name
FROM timetable
LEFT JOIN subject
ON timetable.subject_id != subject.id AND timetable.class_id = subject.class_id
WHERE timetable.class_id = 1 and timetable.section_id =1发布于 2018-01-29 05:05:20
这个简单的查询起作用了。
SELECT id, subject_name FROM subject WHERE class_id = 1
AND id NOT IN (SELECT subject_id from timetable where section_id=1)发布于 2018-01-29 05:07:22
我仍然认为这是一个重复的问题。尽管你的问题有点复杂。所以试试这个:
SELECT subject.id, subject.subject_name
FROM subject
LEFT JOIN timetable
ON timetable.subject_id = subject.id
AND timetable.class_id = subject.class_id
AND timetable.section_id = 1
WHERE subject.class_id = 1
AND timetable.id IS NULLhttps://stackoverflow.com/questions/48491010
复制相似问题