OneTrueLookupTableGoodAliases.sql

SELECT	ForthcomingBooking.Id,
	ForthcomingBooking.Start,
	ForthcomingBooking.Finish,
	RoomType.Name,
	BookingStatus.Name,
	RoomSize.Name
FROM	Booking ForthcomingBooking
	INNER JOIN Lookup RoomType on RoomType.Id = ForthcomingBooking.RoomTypeId
	INNER JOIN Lookup BookingStatus on BookingStatus.Id = ForthcomingBooking.StatusId
	INNER JOIN Lookup RoomSize on RoomSize.Id = ForthcomingBooking.RoomeSizeId
WHERE	ForthcomingBooking.Start BETWEEN GETDATE() AND GETDATE() + 7