Connections database table
From TaskDepender
(→Disconnect) |
(→Disconnect) |
||
Line 65: | Line 65: | ||
This is done by creating a inner join of the [[Selected tasks database table|selected tasks]] and [[Selected deliverables database table|selected deliverables]]. | This is done by creating a inner join of the [[Selected tasks database table|selected tasks]] and [[Selected deliverables database table|selected deliverables]]. | ||
− | Next, the resulting table can be joined to create a table of <tt>Id</tt>s of connections with the connections table for which the join predicate is when the <tt>TaskId</tt>s and the <tt>DeliverableId</tt>'s correspond. | + | Next, the resulting table can be joined to create a table of <tt>Id</tt>s of connections with the [[[[Connections database table|connections table]] for which the join predicate is when the <tt>TaskId</tt>s and the <tt>DeliverableId</tt>'s correspond. |
Finally, the delete statement can simply remove all the connections with the <tt>Id</tt> in this resulting table. | Finally, the delete statement can simply remove all the connections with the <tt>Id</tt> in this resulting table. |