Posted by Ravi on 05/24/07 12:22

Hi,
Before alloting a room check the rooms like

select count(roomid) from maproomstudent mp ,rooms where
room.roomid=mp.roomid

after this check if count >=2 don't allot otherwise allot it

[Back to original message]