Cita:
Código:
SELECT *
FROM room_selected, reservation, room
WHERE reservation.paid =2
AND room_selected.reservation_id = reservation.id
AND room_selected.room_id = room.id
Juraría que estás haciendo un producto cartesiano, en lugar de una consulta múltiple, que supongo es lo que deseas. Has probado con INNER JOIN? Algo al estilo de:
Código:
SELECT *
FROM (room_selected INNER JOIN reservation
ON reservation.paid =2 AND room_selected.reservation_id = reservation.id)
INNER JOIN room ON room_selected.room_id = room.id
(o similar, que no he comprobado si la sintaxis es correcta).