Hi every one,
I’m looking for a query that adds two counts together,
my queries are:
(SELECT distinct Room. [Room Type] AS [**Room Type** ] , COUNT (distinct Room.[Room No]) AS [No. Of Rooms Left]
FROM SiteHotel INNER JOIN Room ON SiteHotel.HotelID = Room.HotelID INNER JOIN Reserve ON Room.[Room No] = Reserve.[Room No]
WHERE (@Sdate NOT BETWEEN Reserve.[Chick-in] AND Reserve.[Chick-out]) AND (@Edate NOT BETWEEN Reserve.[Chick-in] AND Reserve.[Chick-out]) AND (SiteHotel.City = @City) AND (Reserve.[Chick-in] NOT BETWEEN @Sdate AND @Edate) AND (Reserve.[Chick-out] NOT BETWEEN @Sdate AND @Edate) OR(@Sdate = Reserve.[Chick-out]) AND (@Edate = Reserve.[Chick-in]) AND (Reserve.[Chick-in] = @Edate) AND (Reserve.[Chick-out] = @Sdate)
GROUP BY [Room Type] )
(SELECT distinct Room. [Room Type] AS [**Room Type** ] , COUNT (distinct Room.[Room No]) AS [No. Of Rooms Left]
FROM SiteHotel INNER JOIN Room ON SiteHotel.HotelID = Room.HotelID
WHERE (SiteHotel.City = @City) AND (Room.[Room No] NOT IN
(SELECT [Room No]
FROM Reserve
WHERE (SiteHotel.HotelID = HotelID)))
GROUP BY [Room Type] )
and I want to merge these two queries together ,and adds the two counts and put the result in one column
Thanks in advance
