I have the same question and I don't think the stackoverflow post answered my question. I have data from two classes that are connected by edges. Lets say that in class A I have name and last name, and in class B I have username (this is not really the case). When I execute a query using unionall() I get rows of the data from class A and then seperate rows with the data in class B. How can I have it all on the same row. My query is the following:
select expand($c) Let $a = (select field1, field2 from class1), $b = (select field1 from (select expand(in()) from class2), $c = unionall($a,$b) Here I have edges going from class1 to class2. Thanks On Monday, July 14, 2014 at 7:02:32 AM UTC-4, Lvc@ wrote: > > You've got the answer on Stack Overflow: > http://stackoverflow.com/questions/24701947/orientdb-relationship-betwen-to-classes-results-same-row > > Lvc@ > > > On 11 July 2014 18:04, lrt <[email protected] <javascript:>> wrote: > >> hi, Im new working with OrientDB, I have two classes extended of >> OGraphVertex and one class extended of OGraphEdge, when i execute the next >> query I recibe my Tag in a row and the child in other row, I want do an >> union of all of this for show in a report list (the same like use joins in >> MySQL), Some one can help me with this query? >> >> traverse out from ( traverse out_tagsparent from (select * from Tags >> where @rid = #16:10) ) >> >> Regards >> >> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- 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.
