Changeset 24156 for branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql

Timestamp:

May 12, 2009, 6:52:23 PM (17 years ago)

Author:

Paul Price

Message:

Fix database/query error.

File:

• branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql (modified) (1 diff)

branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql

@@ -11 +11 @@
 JOIN magicRun USING(magic_id)
 JOIN rawExp USING(exp_id)
-LEFT JOIN magicNodeResult
-    ON magicTree.magic_id = magicNodeResult.magic_id
-    AND magicTree.node = magicNodeResult.node
+LEFT JOIN magicNodeResult USING(magic_id, node)
 WHERE
     magicRun.state = 'new'