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.