Select Hotels1.HotelCode from Hotels Hotels1 where hotels1.SerialNumber=1

#

Select HotelCode from hotels

#

select HotelName from hotels

#

Select HotelName from Hotels 
where HotelCode = (Select Hotels1.HotelCode from 
Hotels Hotels1 where hotels1.SerialNumber=1)

#

SELECT STATUS FROM FINANCIALEODS 
WHERE HOTELCODE = (Select Hotels1.HotelCode from 
Hotels Hotels1 where hotels1.SerialNumber=1)
AND FISCALDATE = CURRENT_DATE() -1
#

Select sum(room) as RoomsRevenue, sum(Food) as FoodRevenue, 
sum(beverage) as BeverageRevenue, sum(other) as OtherRevenue, 
sum(room+food+beverage+other) as TotalRevenue, 
sum(RmNts) as RoomsSold, sum(GstNts) as TotalGuests, 
sum(room)/sum(RmNts) as AvgRoomRate, sum(room)/sum(GstNts) as AvgGuestRate, 
sum(room+food+beverage+other)/sum(RmNts) as AvgRoomSpend, 
sum(room+food+beverage+other)/sum(GstNts) as AvgGuestSpend 
from GeneralStatistics where FiscalDate = current_date() -1 
and RecordType=0 
and HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT  RoomsReserved / HardRooms  as OccupancyPerCent FROM  HotelAvailability 
WHERE AvailDate = (Current_Date() -1) 
AND RoomType = '' 
AND RoomClass = '' 
and HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT sum(OOOAvailability.NumberRooms)  FROM OOOAvailability 
WHERE OOOAvailability.AvailDate=current_date() -1 
AND OOOAvailability.RoomType= '' 
AND OOOAvailability.RoomClass='' 
and OOOAvailability.HotelCode = (Select Hotels1.HotelCode from 
Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT HotelAvailability.RoomsAvailable, HotelAvailability.GuaranteedRooms,  
HotelAvailability.ConfirmedRooms, HotelAvailability.UnconfirmedRooms, 
HotelAvailability.GroupRooms, RoomsReserved/HardRooms, 
HotelAvailability.UnsoldAllocations, HotelAvailability.UnnamedGroupRooms 
FROM HotelAvailability HotelAvailability 
WHERE HotelAvailability.AvailDate=current_date() 
AND HotelAvailability.RoomType='' 
AND HotelAvailability.RoomClass='' 
and HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT HardRooms FROM HotelAvailability HotelAvailability 
WHERE HotelAvailability.AvailDate is null 
and HotelAvailability.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
and HotelAvailability.RoomType = '' 
AND HotelAvailability.RoomClass = ''
#

SELECT sum(OOOAvailability.NumberRooms)  FROM OOOAvailability  
WHERE OOOAvailability.AvailDate=current_date() 
AND OOOAvailability.RoomType='' AND OOOAvailability.RoomClass='' 
and OOOAvailability.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)

#

SELECT Count(roomsetup.RoomStatus) FROM roomsetup  
WHERE roomsetup.RoomStatus = 4 
and Hotelcode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT groupmaster.GroupCode as GroupCode, lastname+firstname+title as GroupName  
FROM groupmaster, names WHERE groupmaster.Status In (3,4,6) 
AND groupmaster.ArrivalDate=current_date() 
AND groupmaster.SerialNumber=names.parentfileptrsernum 
AND groupmaster.DatabaseNumber=names.parentfileptrdbnum 
AND names.ParentFileNumber = 1510 
AND groupmaster.hotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT DISTINCT names.Title, names.FirstName as Forename, names.LastName as Surname 
FROM NameIndex,names  
WHERE NameIndex.ArrivalDate=current_date() 
AND NameIndex.Status=2 
AND NameIndex.ParentFileStatus In (3,4,6) 
AND NameIndex.PrimeNamePtrSernum=names.serialnumber 
AND NameIndex.PrimeNamePtrDbnum=names.databasenumber 
AND names.ApplicationFlags=32768 AND names.ParentFileNumber=1500 
AND NameIndex.Hotelcode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT groupmaster.GroupCode, names.lastname + names.firstname + names.title 
as GroupName FROM groupmaster,names 
WHERE groupmaster.Status = 1 
AND groupmaster.DepartureDate<>current_date() 
AND groupmaster.SerialNumber=names.parentfileptrsernum 
AND groupmaster.DatabaseNumber=names.parentfileptrdbnum 
AND names.ParentFileNumber=1510 
AND groupmaster.hotelCode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT DISTINCT RoomSetup.RoomNumber, Names.Title, Names.FirstName, Names.LastName 
FROM Bookinglines Bookinglines, Names Names, ReservationLink, RoomAssignment, RoomSetup 
WHERE Bookinglines.Status=1 
AND Bookinglines.Hotelcode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
AND RoomAssignment.ParentFileNumber = 1200 
AND Bookinglines.SerialNumber=RoomAssignment.parentFilePtrSernum 
AND Bookinglines.DatabaseNumber=RoomAssignment.ParentFilePtrDbnum 
AND RoomSetup.SerialNumber=RoomAssignment.RoomPtrSernum 
AND RoomSetup.DatabaseNumber=RoomAssignment.RoomPtrDbnum 
AND ReservationLink.ParentFileNumber = 1300 
AND ReservationLink.ParentFilePtrSernum=RoomAssignment.SerialNumber 
AND ReservationLink.ParentFilePtrDbnum=RoomAssignment.DatabaseNumber 
AND ReservationLink.NamePtrSernum=Names.SerialNumber 
AND ReservationLink.NamePtrDbnum=Names.DatabaseNumber 
AND Names.ApplicationFlags=32768 
ORDER BY Names.LastName, Names.FirstName
#

SELECT RoomSetup.RoomNumber as OOORoomNumbers FROM RoomSetup 
WHERE RoomSetup.RoomStatus=5 
and roomsetup.Hotelcode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT roomsetup.RoomNumber AS DNARoomNumbers, 
LEFT(freetext.vdata,32) as Reason 
FROM roomsetup  LEFT OUTER JOIN freetext 
ON freetext.ParentFilePtrSernum = roomsetup.serialnumber 
AND freetext.ParentFilePtrDbnum=roomsetup.databasenumber 
AND freetext.ParentFileNumber=1270 
AND freetext.SecondaryKeyInfo = 'DNA' 
WHERE roomsetup.RoomStatus = 4 
AND roomsetup.Hotelcode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT Names.LastName, Names.FirstName, Names.Title, Addresses.AddressLine2, 
Addresses.AddressLine3, Addresses.AddressLine4, Addresses.AddressLine5, 
Addresses.PostCode1, Addresses.PostCode2, Guests.NumberOfStays, 
Sum(StayDetails.NumberOfNights),Sum(StayDetails.RoomRevenue), 
Sum(StayDetails.FoodRevenue),Sum(StayDetails.BeverageRevenue), 
Sum(StayDetails.OtherRevenue), 
Sum(staydetails.roomrevenue+StayDetails.FoodRevenue+staydetails.beveragerevenue+staydetails.otherrevenue), 
Guests.CreatedDateDate,Guests.MarketSegment,Guests.Residency, 
Guests.Companycode , Guests.PromotionCode, Guests.VIPStatus 
FROM Addresses, Guests, Names, StayDetails 
WHERE StayDetails.GuestPtrSernum = Guests.SerialNumber 
AND StayDetails.GuestPtrDbnum = Guests.DatabaseNumber 
AND Guests.SerialNumber = Names.ParentFilePtrSernum 
AND Guests.DatabaseNumber = Names.ParentFilePtrDbnum 
AND Addresses.ParentFilePtrSernum = Guests.SerialNumber 
AND Addresses.ParentFilePtrDbnum = Guests.DatabaseNumber 
AND Names.ParentFileNumber=1500 
AND Addresses.ParentFileNumber=1500 
and Addresses.AddressLine2 <> '                                      ' 
GROUP BY Names.LastName, Names.FirstName, Names.Title, 
Addresses.AddressLine2, Addresses.AddressLine3, Addresses.AddressLine4, 
Addresses.AddressLine5, Addresses.PostCode1, Addresses.PostCode2, 
Guests.NumberOfStays, Addresses.ParentFileNumber, 
Guests.CreatedDateDate,Guests.MarketSegment,Guests.Residency, 
Guests.Companycode , Guests.PromotionCode, Guests.VIPStatus 
HAVING(Addresses.ParentFileNumber = 1500)
#

SELECT Names.LastName, Names.FirstName, Names.Title, Guests.NumberOfStays, 
Sum(StayDetails.NumberOfNights) as TotalStayNights, 
Sum(StayDetails.RoomRevenue) as RoomRevenue, 
Sum(StayDetails.FoodRevenue) as FoodRevenue, 
Sum(StayDetails.BeverageRevenue) as BeverageRevenue, 
Sum(StayDetails.OtherRevenue) as OtherRevenue, 
Sum(staydetails.roomrevenue+StayDetails.FoodRevenue+staydetails.beveragerevenue +staydetails.otherrevenue)  as TotalRevenue 
FROM Guests, Names, StayDetails 
WHERE StayDetails.GuestPtrSernum = Guests.SerialNumber 
AND StayDetails.GuestPtrDbnum = Guests.DatabaseNumber 
AND Guests.SerialNumber = Names.ParentFilePtrSernum 
AND Guests.DatabaseNumber = Names.ParentFilePtrDbnum 
AND ((Names.ParentFileNumber=1500)) 
GROUP BY Names.LastName, Names.FirstName, Names.Title, Guests.NumberOfStays
#

Select HotelName from Hotels  where Hotelcode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

select RoomSetup.RoomNumber,Bookinglines.RoomType, Bookinglines.RoomClass, 
Autonumbers.Number,Bookinglines.RateCode,Bookinglines.StartDate,Bookinglines.EndDate, 
Bookinglines.NumberOfAdultsInSeg, Bookinglines.NumberOfChildren,
Bookinglines.NumberOfInfants, Names.Title,Names.FirstName,Names.LastName,
ReservationHeader.GroupCode FROM Autonumbers , Bookinglines, Names, 
ReservationHeader, ReservationLink, RoomAssignment,RoomSetup 
WHERE Bookinglines.Status = 1 AND Bookinglines.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
AND ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum 
AND ReservationHeader.DatabaseNumber=BookingLines.ParentFilePtrDbnum 
AND Autonumbers.ParentFileNumber=1180 
AND Autonumbers.ParentFilePtrSernum=ReservationHeader.SerialNumber 
AND Autonumbers.ParentFilePtrDbnum=ReservationHeader.DatabaseNumber 
AND RoomAssignment.ParentFileNumber=1200 
AND Bookinglines.SerialNumber=RoomAssignment.parentFilePtrSernum 
AND Bookinglines.DatabaseNumber=RoomAssignment.ParentFilePtrDbnum 
AND RoomSetup.SerialNumber=RoomAssignment.RoomPtrSernum 
AND RoomSetup.DatabaseNumber=RoomAssignment.RoomPtrDbnum 
AND ReservationLink.ParentFileNumber=1300 
AND ReservationLink.ParentFilePtrSernum=RoomAssignment.SerialNumber 
AND ReservationLink.ParentFilePtrDbnum=RoomAssignment.DatabaseNumber 
AND ReservationLink.NamePtrSernum=Names.SerialNumber 
AND ReservationLink.NamePtrDbnum=Names.DatabaseNumber 
order by Names.LastName
#

SELECT Stayovers.Room,Stayovers.RoomType,Stayovers.RoomClass,
Stayovers.ResNumber, Stayovers.RateCode,Stayovers.BkgLineStart, 
Stayovers.BkgLineEnd, Stayovers.AdultsOnBkgLine, 
Stayovers.ChildrenOnBkgLine,Stayovers.InfantsOnBkgLine, 
Stayovers.Title, Stayovers.FirstName, Stayovers.GuestLastName,Stayovers.GroupCode 
FROM Stayovers where Stayovers.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)
#

SELECT RoomSetup.RoomNumber,Bookinglines.RoomType, Bookinglines.RoomClass, 
Autonumbers.Number,Bookinglines.RateCode,Bookinglines.StartDate,
Bookinglines.EndDate, Bookinglines.NumberOfAdultsInSeg, 
Bookinglines.NumberOfChildren,Bookinglines.NumberOfInfants, 
Names.Title,Names.FirstName,Names.LastName,ReservationHeader.GroupCode 
FROM Autonumbers, Bookinglines, Names, ReservationHeader, 
ReservationLink, RoomAssignment, RoomSetup 
WHERE Bookinglines.HotelCode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
AND Bookinglines.Status In (7,16) 
AND ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum 
AND ReservationHeader.DatabaseNumber=BookingLines.ParentFilePtrDbnum 
AND Autonumbers.ParentFileNumber=1180 
AND Autonumbers.ParentFilePtrSernum = ReservationHeader.SerialNumber 
And Autonumbers.ParentFilePtrDbnum = ReservationHeader.DatabaseNumber 
And RoomAssignment.ParentFileNumber = 1200 
And Bookinglines.SerialNumber = RoomAssignment.ParentFilePtrSernum 
And Bookinglines.DatabaseNumber = RoomAssignment.ParentFilePtrDbnum 
And RoomSetup.SerialNumber = RoomAssignment.RoomPtrSernum 
And RoomSetup.DatabaseNumber = RoomAssignment.RoomPtrDbnum 
And ReservationLink.ParentFileNumber = 1200 
And ReservationLink.ParentFilePtrSernum = Bookinglines.SerialNumber 
And ReservationLink.ParentFilePtrDbnum = Bookinglines.DatabaseNumber 
And ReservationLink.NamePtrSernum = Names.SerialNumber 
And ReservationLink.NamePtrDbnum = Names.DatabaseNumber 
And Bookinglines.EndDate = CURRENT_DATE()
#

SELECT RoomSetup.RoomNumber,Bookinglines.RoomType, 
Bookinglines.RoomClass, Autonumbers.Number,Bookinglines.RateCode,
Bookinglines.StartDate,Bookinglines.EndDate, Bookinglines.NumberOfAdultsInSeg, 
Bookinglines.NumberOfChildren,Bookinglines.NumberOfInfants, 
Names.Title,Names.FirstName,Names.LastName,ReservationHeader.GroupCode 
FROM Autonumbers, Bookinglines, Names, ReservationHeader, ReservationLink, 
RoomAssignment, RoomSetup 
WHERE Bookinglines.HotelCode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
AND Bookinglines.Status=1 
AND ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum 
AND ReservationHeader.DatabaseNumber=BookingLines.ParentFilePtrDbnum 
AND Autonumbers.ParentFileNumber=1180 
AND Autonumbers.ParentFilePtrSernum=ReservationHeader.SerialNumber 
AND Autonumbers.ParentFilePtrDbnum=ReservationHeader.DatabaseNumber 
AND RoomAssignment.ParentFileNumber=1200 
AND Bookinglines.SerialNumber=RoomAssignment.parentFilePtrSernum 
AND Bookinglines.DatabaseNumber=RoomAssignment.ParentFilePtrDbnum 
AND RoomSetup.SerialNumber=RoomAssignment.RoomPtrSernum 
AND RoomSetup.DatabaseNumber=RoomAssignment.RoomPtrDbnum 
AND ReservationLink.ParentFileNumber=1300 
AND ReservationLink.ParentFilePtrSernum=RoomAssignment.SerialNumber 
AND ReservationLink.ParentFilePtrDbnum=RoomAssignment.DatabaseNumber 
AND ReservationLink.NamePtrSernum=Names.SerialNumber 
AND ReservationLink.NamePtrDbnum=Names.DatabaseNumber 
AND Bookinglines.EndDate=current_date() 
AND Bookinglines.NextSegPtrSernum=0
#

SELECT RoomSetup.RoomNumber,Bookinglines.RoomType, Bookinglines.RoomClass, 
Autonumbers.Number,Bookinglines.RateCode,Bookinglines.StartDate,Bookinglines.EndDate, 
Bookinglines.NumberOfAdultsInSeg, Bookinglines.NumberOfChildren,
Bookinglines.NumberOfInfants, Names.Title, Names.FirstName, Names.LastName,
ReservationHeader.GroupCode 
FROM Autonumbers, Bkglinestatus, Bookinglines, Names, ReservationHeader, 
ReservationLink, RoomAssignment, RoomSetup 
WHERE Bookinglines.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
AND Bookinglines.Status In (3,4,6) 
AND Bookinglines.Status=bkglinestatus.bkgstatnumber 
AND ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum 
AND ReservationHeader.DatabaseNumber = Bookinglines.ParentFilePtrDbnum 
And Autonumbers.ParentFileNumber = 1180 
And Autonumbers.ParentFilePtrSernum = ReservationHeader.SerialNumber 
And Autonumbers.ParentFilePtrDbnum = ReservationHeader.DatabaseNumber 
And RoomAssignment.ParentFileNumber = 1200 
And Bookinglines.SerialNumber = RoomAssignment.ParentFilePtrSernum 
And Bookinglines.DatabaseNumber = RoomAssignment.ParentFilePtrDbnum 
And RoomSetup.SerialNumber = RoomAssignment.RoomPtrSernum 
And RoomSetup.DatabaseNumber = RoomAssignment.RoomPtrDbnum 
And ReservationLink.ParentFileNumber = 1300 
And ReservationLink.ParentFilePtrSernum = RoomAssignment.SerialNumber 
And (ReservationLink.ParentFilePtrDbnum = RoomAssignment.DatabaseNumber) 
And (ReservationLink.NamePtrSernum = Names.SerialNumber) 
And (ReservationLink.NamePtrDbnum = Names.DatabaseNumber) 
And (Bookinglines.StartDate = current_date())
#

SELECT '---',Bookinglines.RoomType, Bookinglines.RoomClass, Autonumbers.Number,
Bookinglines.RateCode,Bookinglines.StartDate, Bookinglines.EndDate, 
Bookinglines.NumberOfAdultsInSeg,Bookinglines.NumberOfChildren, 
Bookinglines.NumberOfInfants, Names.Title,Names.FirstName,Names.LastName,
ReservationHeader.GroupCode FROM Autonumbers , Bkglinestatus, 
Bookinglines, Names, ReservationHeader, ReservationLink 
WHERE Bookinglines.HotelCode  = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
and Bookinglines.Status In (3,4,6) 
And Bookinglines.Status=bkglinestatus.bkgstatnumber 
AND ReservationHeader.SerialNumber=BookingLines.ParentFilePtrSernum 
AND ReservationHeader.DatabaseNumber=BookingLines.ParentFilePtrDbnum 
AND Autonumbers.ParentFileNumber=1180 
AND Autonumbers.ParentFilePtrSernum=ReservationHeader.SerialNumber 
AND Autonumbers.ParentFilePtrDbnum=ReservationHeader.DatabaseNumber 
AND ReservationLink.ParentFileNumber=1200 
AND ReservationLink.ParentFilePtrSernum=BookingLines.SerialNumber 
AND ReservationLink.ParentFilePtrDbnum=Bookinglines.DatabaseNumber 
AND ReservationLink.NamePtrSernum=Names.SerialNumber 
AND ReservationLink.NamePtrDbnum=Names.DatabaseNumber 
AND Bookinglines.StartDate=current_date() 
order by Names.LastName
#

SELECT RoomSetup.RoomNumber,RoomSetup.RoomType, RoomSetup.RoomClass, 
MaintenanceHeader.MaintenanceNumber, RoomAssignment.RoomAllocStartDate, 
RoomAssignment.RoomAllocEndDate, MaintenanceHeader.Description 
FROM MaintenanceHeader, RoomAssignment, RoomSetup 
WHERE MaintenanceHeader.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1) 
AND RoomSetup.RoomStatus=5 
AND RoomAssignment.ParentFileNumber=1600 
AND RoomAssignment.ParentFilePtrSernum=MaintenanceHeader.SerialNumber 
AND RoomAssignment.ParentFilePtrDbnum=MaintenanceHeader.DatabaseNumber 
AND RoomSetup.SerialNumber=RoomAssignment.RoomPtrSernum 
AND RoomSetup.DatabaseNumber=RoomAssignment.RoomPtrDbnum 
AND RoomAssignment.RoomAllocEndDate>=current_date() 
AND RoomAssignment.RoomAllocStartDate<=current_date()
#

SELECT RoomSetup.RoomNumber,RoomSetup.RoomType,RoomSetup.RoomClass, 
MaintenanceHeader.MaintenanceNumber,RoomAssignment.RoomAllocStartDate, 
RoomAssignment.RoomAllocEndDate,MaintenanceHeader.Description 
FROM MaintenanceHeader, RoomAssignment,RoomSetup 
WHERE MaintenanceHeader.HotelCode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)  
and RoomSetup.RoomStatus<>5 
AND RoomAssignment.ParentFileNumber=1600 
AND RoomAssignment.ParentFilePtrSernum=MaintenanceHeader.SerialNumber 
AND RoomAssignment.ParentFilePtrDbnum=MaintenanceHeader.DatabaseNumber 
AND RoomSetup.SerialNumber=RoomAssignment.RoomPtrSernum 
AND RoomSetup.DatabaseNumber=RoomAssignment.RoomPtrDbnum 
AND RoomAssignment.RoomAllocStartDate=current_date()
#

 select generalstatistics.fiscaldate, 'Named Groups', 
 sum(generalstatistics.Rmarr), sum(generalstatistics.RmNts), 
 sum(generalstatistics.GstNts) , sum(generalstatistics.room) 
 from generalstatistics, bookinglines 
 where generalstatistics.hotelcode = (Select Hotels1.HotelCode from Hotels Hotels1 
 where hotels1.SerialNumber=1)   
 and generalstatistics.fiscaldate between current_date() and current_date() + 10 
 and generalstatistics.RecordType = 0 
 and generalstatistics.parentfilenumber=1200 
 and generalstatistics.parentfileptrsernum=bookinglines.serialnumber 
 and generalstatistics.parentfileptrdbnum=bookinglines.databasenumber 
 and bookinglines.availfilenumber = 1510 
 group by generalstatistics.fiscaldate, generalstatistics.hotelcode 
 Union ALL  select stats2.fiscaldate, 'UnnamedGroups', 
 sum(stats2.Rmarr), sum(stats2.RmNts), 
 sum(stats2.GstNts), sum(stats2.room) 
 from generalstatistics stats2 
 where stats2.hotelcode = (Select Hotels1.HotelCode from Hotels Hotels1 
where hotels1.SerialNumber=1)   
 and stats2.fiscaldate between current_date() and current_date() + 10
 and stats2.RecordType = 0 
 and stats2.parentfilenumber=1510 
 group by stats2.fiscaldate, stats2.hotelcode 
 Union ALL  select stats3.fiscaldate, 'Individuals', 
 sum(stats3.Rmarr), sum(stats3.RmNts), 
 sum(stats3.GstNts) , sum(stats3.room) 
 from generalstatistics stats3 , bookinglines bookinglines2 
 where stats3.hotelcode = (Select Hotels1.HotelCode from Hotels Hotels1 
 where hotels1.SerialNumber=1)  
 and stats3.fiscaldate between current_date() and current_date() + 10
 and stats3.RecordType = 0 
 and stats3.parentfilenumber=1200 
 and stats3.parentfileptrsernum=bookinglines2.serialnumber 
 and stats3.parentfileptrdbnum=bookinglines2.databasenumber 
 and bookinglines2.availfilenumber <> 1510 
 group by stats3.fiscaldate, stats3.hotelcode
#

SELECT Number + AnswerBack FROM TelephoneNumbers 
where number like '%@%'
#