Marcus wrote:
>
> $sql_current_node_data = "
> SELECT Nodes.NodeTitle, Nodes.NodeText,
> Nodereferences.ReferenceType
> FROM Nodes, Nodereferences
> WHERE Nodes.NodeID = $current_node
> AND Nodereferences.RecipientNodeID =$current_node";
As it says (somewhere :-) in the docs you must specify an equijoin
either by using NATURAL JOIN, or JOIN USING, or JOIN ON, or by having an
equal condition in the where clause explicitly linking the shared
columns so this should work:
SELECT Nodes.NodeTitle,Nodes.NodeText,Nodereferences.ReferenceType
FROM Nodes, Nodereferences
WHERE Nodereferences.RecipientNodeID = Nodes.NodeID
AND Nodes.NodeID = $current_node
> my $sql_children = "
> SELECT Nodes.NodeID, Nodes.NodeTitle,
> NodeReferences.NodeReferenceID
> FROM Nodes, NodeReferences
> WHERE Nodes.NodeID = NodeReferences.RecipientNodeID
> AND NodeReferences.ReferringNodeID = $current_node
> AND NodeReferences.ReferenceType = 'child' ";
That one has the required equijoin condition it should work, what
happened when you tried it?
(I assume that $current_node is a number, otherwise it needs to be
quoted or passed as a placeholder.)
--
Jeff
