java.sql.SQLException:子查询为Guest house返回多行

loading...


0

实际上我的查询应显示以下查询的宾馆名称,房间,预订房间,可用房间:

选择(a.hotel_name)作为hotel_name,(htl_room_information.id_hotel)作为total_room,(SELECT(htl_room_information.id_hotel)作为房间FROM htl_booking_detail,htl_branch_info_lang b,htl_room_information WHERE b.id = htl_booking_detail.id_hotel和htl_booking_detail.id_room = htl_room_information.id和{}和b.hotel_name = a.hotel_name)Booked_room,(htl_room_information.id_hotel) - (选择htl_room_information.id_hotel作为房间来自htl_booking_detail,htl_branch_info_lang b,htl_room_information WHERE b.id = htl_booking_detail.id_hotel和htl_booking_detail.id_room = htl_room_information .id和{}和b.hotel_name = a.hotel_name)可用于htl_room_information,htl_branch_info_lang a其中htl_room_information.id_hotel = a.id

但它显示错误如下:

java.sql.SQLException:子查询返回多行

请帮忙解决这个问题 .

loading...

0回答

No Data

评论

暂时没有评论!