1.SELECT DB_table.table_name,DB_time.startSlot
2.FROM DB_time CROSS JOIN DB_table
3.WHERE
4. (SELECT DB_table.table_name,DB_time.startSlot FROM DB_time CROSS JOIN DB_table)
5.NOT IN (
6. SELECT DB_table.table_name,DB_time.startSlot FROM DB_time CROSS JOIN DB_table LEFT JOIN tspace ON (DB_time.time_id = tspace.time_id AND DB_table.table_id = tspace.table_id ) WHERE tspace.rdate = '2019-04-07')
Quote:
