Re: Problematic SQL statement

[Ramalingam Chelliah]

Hi,

I have (could not ) used subqueries ( MySQL version 4.0.18)

However ,here is a trial ...

JOIN the same table twice ON condition link is same.
and check if ,say, node3 is there invloved in the result set.

SELECT X.node,'--->',Y.node,X.link
FROM
linktable as X
LEFT OUTER JOIN
linktable as Y
ON X.link=Y.link
LEFT OUTER JOIN
linktable as Z
ON X.link=Z.link
WHERE Z.node='node3' ;

Hope this helps you ...

Regards ,
Ram.







We Learn the Most When we have to Invent