i have 3 tables in database: room, roomtype , booking.
room entity:
@id @generatedvalue(strategy = generationtype.identity) private long roomid; private long doorcode; @manytoone(optional = false, fetch = fetchtype.lazy) @joincolumn(name = "roomtypeid") private roomtype roomtype; roomtype entity:
@id @generatedvalue(strategy = generationtype.identity) private long roomtypeid; private string name; private string photo; booking entity:
@id @generatedvalue(strategy = generationtype.identity) private long bookingid; @manytoone(optional = false, fetch = fetchtype.lazy) @joincolumn(name = "roomid") private room room; private date fechar; i want make join between room , booking see rooms between dates when try make join, can between room , roomtype entities.
"select u room h left join h.roomtype" how join room booking?
Comments
Post a Comment