java - 错误代码 1241，SQL 状态 21000 : Operand should contain 1 column(s)

Question

我在处理查询时收到以下错误代码:

Error code 1241, SQL state 21000: Operand should contain 1 column(s)

select * from room
where room.id in
(
select room.id, room.name, room.capacity, booking.start, booking.end
from room
left join booking on room.id = booking.room
)

Answer 1

您不需要子查询。你可以这样尝试:

select *
from room
left join booking on room.id = booking.room