select hotel.*, hotels.type
from pe,se
where p.hotel_Id = s.S_Id
and Type="";
select hotel.*, hotels.type
from pe,se
where select hotel.*, hotels.type
from pe,se
where p.hotel_Id = s.S_Id
and Type="";
select hotel.*, hotels.type
from pe,se
where