Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex Query Help
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00611652
Message ID:
00611939
Vues:
24
Try
SELECT 
		DATEADD(minute, 1, m1.endTime) AS SlotBeginTime,
		DATEADD(minute, @gap, m1.endTime) AS SlotEndTime,
                r1.Description, r1.RoomAvailable 
	FROM meetings m1 
	LEFT JOIN meetings m2 ON ISNULL(m2.beginTime, @DateTimeEnd) > m1.endTime 
		AND (m1.roomID = m2.roomID OR m2.roomID IS NULL)
	LEFT JOIN RoomInfo r1 ON r1.roomID = m1.roomID
...
>One more question
>
>I need to add a join to this table to get information about the room, such as the description and RoomAvailable times. It is linked on the roomid field. Would you mind showing me how to add this join the to query.
>
>Thanks
>Kirk
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform