Thank You Le jeudi 19 mai 2016 22:07:37 UTC+1, [email protected] a écrit : > > Hi > > it's not properly what you asked for but, hope it helps: > > select expand(distinct($c)) from User > let $a=(select expand(distinct(@rid)) from (SELECT expand(out('makeL').in( > 'makeL')) FROM #12:2) where @rid not in (select expand(distinct(@rid)) > from (select expand(both('follow')) from user WHERE @rid=12:2)) and > @rid<>12:2), > $b=(select expand(distinct(@rid)) from (select * from (traverse both( > 'follow') from 12:2 while $depth <= 3) where $depth > 1) where @rid not in > (select expand(distinct(@rid)) from (select expand(both('follow')) from > user WHERE @rid=12:2))), > $c=intersect($a,$b) > > with intersect I intersect the results from the 2 query, unless if you > need to see all the results you can use unionall. > > Regards, > Michela >
-- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
