Anyone have a good SQL snippet for finding duplicate/parallel links in the Select by Attribute dialog? I came up with this, but it does seem to include some false positives. Thought I'd check if anyone had a snippet already built before going into a bunch of time debugging why.

[code][MUID] IN (SELECT SS1_mV1.[MUID] FROM msm_Valve SS1_mV1 INNER JOIN msm_Link SS1_mL1 ON SS1_mV1.FROMNODE = SS1_mL1.FROMNODE AND SS1_mV1.TONODE = SS1_mL1.TONODE)OR [MUID] IN (SELECT SS2_mV1.[MUID] FROM msm_Valve SS2_mV1 INNER JOIN msm_Valve SS2_mV2 ON SS2_mV1.FROMNODE =SS2_mV2.FROMNODE AND SS2_mV1.TONODE = SS2_mV2.TONODE AND SS2_mV1.MUID <> SS2_mV2.MUID) OR [MUID] IN (SELECT SS3_mL1.[MUID] FROM msm_Link SS3_mL1 INNER JOIN msm_Link SS3_mL2 ON SS3_mL1.FROMNODE =SS3_mL2.FROMNODE AND SS3_mL1.TONODE = SS3_mL2.TONODE AND SS3_mL1.MUID <> SS3_mL2.MUID) OR [MUID] IN (SELECT SS4_mL1.[MUID] FROM msm_Valve SS4_mV1 INNER JOIN msm_Link SS4_mL1 ON SS4_mV1.FROMNODE = SS4_mL1.FROMNODE AND SS4_mV1.TONODE = SS4_mL1.TONODE) [/code]