Hello,

How can i make this query ?

select * from Estrada where in=#11:11;  <- this one works because i used @RID
output:

orientdb {db=path_finderC}> select * from Estrada where in=#11:11;

----+------+-------+------+------+------
#   |@RID  |@CLASS |in    |weight|out   
----+------+-------+------+------+------
0   |#12:50|Estrada|#11:11|10    |#11:10
----+------+-------+------+------+------


But i want to do like this:

select * from Estrada where in=(select * from City where name='A'); <- this 
does not work.. i dont know why

orientdb {db=path_finderC}> select * from Estrada where in=(select * from City 
where name='A');

0 item(s) found. Query executed in 0.012 sec(s).

-- 

--- 
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.

Reply via email to