Hi,
Consider a scenario of finding employees working in a department (along
with department details).
In RDBMS SQL we can write something like following:
select E.*, D.DEPT_NAME, D.DEPT_DATA from Employee E, Department D where
E.DEPT_ID = D.DEPT_ID and D.DEPT_ID = 'DEPT1';
In above sql we get details of both employee and department tables.
How can we achieve this with single orientdb query?
Or do we need to fire two queries like following?
select from dept where @rid = #12:20 // This is to get dept details
select expand(in('worksAt')) from dept where @rid=#12:20 limit -1; // This
is to get employees working in dept
Thanks,
Kapil
--
---
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.
