Hi Casper,
The problem is that in the WHERE conditions you can't use FriendsIn and
FamilyOut because they aren't been created yet, I posted you two solutions:
1) without alias
SELECT in('Friends')[0] as FriendsIn, out('Family')[0] as FamilyOut
FROM User
WHERE (
in('Friends')[0] = #30:0
AND
out('Family')[0] = #24:0
)
2) with alias
select from (SELECT in('Friends')[0] as FriendsIn, out('Family')[0] as
FamilyOut FROM User) WHERE FriendsIn = #30:0 AND FamilyOut = #24:0
Hope it helps
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.
