11 lines
388 B
SQL
11 lines
388 B
SQL
|
SELECT -- Incorrect table reservations
|
||
|
|
Left.reservation,
|
||
|
|
datetime (Left.reservation, Left.time_reserve) AS reserved_until,
|
||
|
|
Right.reservation
|
||
|
|
from
|
||
|
|
Bookings AS Left
|
||
|
|
LEFT JOIN Bookings AS Right ON Left.id != Right.id
|
||
|
|
AND Left.id_tables = Right.id_tables
|
||
|
|
WHERE
|
||
|
|
datetime (Right.reservation) BETWEEN datetime (Left.reservation) AND datetime (Left.reservation, Left.time_reserve)
|