wouldn't you want it "select @rid from City where name='A'"
On Saturday, August 15, 2015 at 1:58:51 PM UTC-4, Hernan Lopes wrote:
>
> 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.
