All pastes #234391 Raw Edit

Miscellany

public text v1 · immutable
·published 2006-11-02 14:36 UTC
rendered paste body
SELECT FromNode, ToNode FROM tblPort_Link 
            WHERE FromNode Not In (SELECT Origination FROM tblTempChain WHERE Chain <> 'Non-Outlet') 
            AND FromNode Not In (SELECT Destination FROM tblTempChain WHERE Chain <> 'Non-Outlet') 
            AND ToNode Not In (SELECT Origination FROM tblTempChain WHERE Chain <> 'Non-Outlet') 
            AND ToNode Not In (SELECT Destination FROM tblTempChain WHERE Chain <> 'Non-Outlet') 
            ORDER BY FromNode, ToNode