Hi All,
I am new to OrientDB and have following structure:
1) Vertex - Person - Luca, Jay, Tom, Henry
2) Vertex - Car - Ferrari, Audi, Chevrolet
3) Vertex - Restaurant - Dante, McD, Hyatt
4) Edge - Eats -
Luca -> Eats-> Dante,
Luca -> Eats-> McD
Jay -> Eats -> McD
Tom -> Eats -> Dante
Henry -> Eats -> Dante
5) Edge - Drives -
Luca -> Drives -> Audi
Luca -> Drives -> Ferrari
Jay -> Drives -> Chevrolet
Tom -> Drives ->Audi
Henry -> Drives -> Ferrari
Henry -> Drives -> Chevrolet
Now, i want to write a SQL that lists the name of the Person and the Car
they Drive, who eat at Dante
I tried, "Select expand(in('Eats').out('Drives')) from Restaurant where
name = 'Dante' "
This only prints the name of the Cars, not the name of the Person.
Please, help me with the same.
--
---
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.
