Hello I have 2 vertex: - Article with field content - User with field username
And edge author Is it possible in orientdb return in results fields content and username? Something like this: select content, (select top 1 from user where userid=article.userid) as username from article I only found this solution: traverse in_author from (select * from Article) but it returns all results mixed: e:#11:1->#12:0 #12:0:v(Article)[#12:0]:content:nnn2345 #12:0:v(Article)[#12:0]:modified:1395864706670 #11:1:v(User)[#11:1]:remember:true #11:1:v(User)[#11:1]:username:23456 #11:1:v(User)[#11:1]:email:22@2 #11:1:v(User)[#11:1]:password:11111 e:#11:0->#12:1 #12:1:v(Article)[#12:1]:content:1 #12:1:v(Article)[#12:1]:modified:1395864726851 #11:0:v(User)[#11:0]:remember:true #11:0:v(User)[#11:0]:username:12345 #11:0:v(User)[#11:0]:email:1@11 #11:0:v(User)[#11:0]:password:11111 e:#11:0->#12:2 #12:2:v(Article)[#12:2]:content:2 #12:2:v(Article)[#12:2]:modified:1395864732477 And i need join article and user manualy. Thx -- --- 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.
