I have small problem with OrientDB, and I hope you'll help me. There are classes: Animals class: ----+-----+----+------- # |@RID |species|name ----+-----+-------+------ 0 |#13:0|dog |Max 1 |#13:1|cat |Lulu 2 |#13:2|snake |zigzag ----+-----+-------+------
peson class: ----+-----+----+------- # |@RID |name|animals ----+-----+----+------- 0 |#14:0|John|[2] ----+-----+----+------- where [2] is [#13:0, #13:1] how to get records with person and his animals names, something like RIGHT JOIN in SQL?? I would have an output similar to that: ----+-----+----+------- # |@RID |name|animals.name ----+-----+----+------- 0 |#????|John|Max 1 |#????|John|Lulu ----+-----+----+------- Is there also something like CROSS JOIN? And please tell me why this command doesn't work, and how to fix it. update person add animals = (SELECT @rid FROM animals WHERE name='zigzag') where name = 'John' -- --- 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.
