That does not work
On Sunday, August 16, 2015 at 9:00:48 AM UTC-3, Gary Gendel wrote:
>
>
> 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.
