gistfile1.txt

orientdb {db=vitals-test}> select expand(both('Specializes').both('Accepts').name) from Specialty

----+------+-----
#   |@CLASS|value
----+------+-----
0   |null  |aetna
1   |null  |aetna
----+------+-----

2 item(s) found. Query executed in 0.003 sec(s).

insruanceplan

orientdb {db=vitals-test}> select * from InsurancePlan

----+-----+-------------+-----+----------
#   |@RID |@CLASS       |name |in_Accepts
----+-----+-------------+-----+----------
0   |#12:0|InsurancePlan|aetna|[size=1]  
----+-----+-------------+-----+----------

1 item(s) found. Query executed in 0.002 sec(s).

specialty no query

orientdb {db=vitals-test}> select expand(both('Specializes').both('Accepts')) from Specialty

----+-----+-------------+-----+----------
#   |@RID |@CLASS       |name |in_Accepts
----+-----+-------------+-----+----------
0   |#12:0|InsurancePlan|aetna|[size=1]  
1   |#12:0|InsurancePlan|aetna|[size=1]  
----+-----+-------------+-----+----------

2 item(s) found. Query executed in 0.005 sec(s).

specialty with where clause

orientdb {db=vitals-test}> select expand(both('Specializes').both('Accepts')) from Specialty where both('Specializes').both('Accepts').name = 'aetna'


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