SELECT
A.meetingcode,
roomcode,
meetingname,
to_char(preparetime, ‘hh24:mi’) preparetime,
to_char(endtime, ‘hh24:mi’) endtime,
1 mstate
FROM
vc_meeting a
LEFT JOIN (
SELECT
meetingcode,
roomcode
FROM
vc_meeting_room
WHERE
roomcode = ‘e1741b61806d45878b6f3a98fe1da2cd’
) b ON a.meetingcode = b.meetingcode
WHERE
meetingstate < 2
AND ( ( preparetime >= TO_DATE(‘2021-03-26 14:01:00’, ‘yyyy-MM-dd HH24:mi:ss’)
AND ( preparetime <= TO_DATE(‘2021-03-26 15:30:00’, ‘yyyy-MM-dd HH24:mi:ss’) ) )
OR ( endtime >= TO_DATE(‘2021-03-26 14:01:00’, ‘yyyy-MM-dd HH24:mi:ss’)
AND ( endtime <= TO_DATE(‘2021-03-26 15:30:00’, ‘yyyy-MM-dd HH24:mi:ss’) ) ) )
————>AND b.meetingcode is not null(注意这句话)
ORDER BY
preparetime ASC
在关联查询时两张边查询结果主表会被自动补全 但是如果会出现垃圾数据这个时候就需要对关联表进行限制就比如这个自动补全后meetingcode不能为null
09-02
1741