Connections database table - TaskDepender

Connections database table

From TaskDepender
Jump to: navigation, search
(Disconnect)
(Disconnect)
Line 123: Line 123:
  
 
(
 
(
 
+
  SELECT Id
 
+
  FROM
 
+
    Connections,
  SELECT t.Id TaskId, d.Id DeliverableId, %d IsDependency,
+
    (SELECT t.Id TaskId, d.Id DeliverableId FROM SelectedTasks t, SelectedDeliverables d) AS SelectedElements
  FROM SelectedTasks t, SelectedDeliverables d
+
  WHERE
 
+
    Connections.TaskId = SelectedElements.TaskId AND
 +
    Connections.DeliverableId = SelectedElements.DeliverableId
 
)
 
)
  

Revision as of 21:21, 22 November 2011