Connections database table
From TaskDepender
(→Disconnect) |
(→Disconnect) |
||
| Line 121: | Line 121: | ||
DELETE FROM Connections | DELETE FROM Connections | ||
WHERE Id IN | WHERE Id IN | ||
| − | |||
( | ( | ||
SELECT Id | SELECT Id | ||
FROM | FROM | ||
Connections, | Connections, | ||
| − | (SELECT t.Id TaskId, d.Id DeliverableId FROM SelectedTasks t, SelectedDeliverables d) AS | + | (SELECT t.Id TaskId, d.Id DeliverableId FROM SelectedTasks t, SelectedDeliverables d) AS SelectedConnections |
WHERE | WHERE | ||
| − | Connections.TaskId = | + | Connections.TaskId = SelectedConnections.TaskId |
| − | Connections.DeliverableId = | + | AND |
| + | Connections.DeliverableId = SelectedConnections.DeliverableId | ||
) | ) | ||
| − | |||
| − | |||
</syntaxhighlight> | </syntaxhighlight> | ||
