On Wednesday, February 18, 2015 at 11:34:13 AM UTC+8, Martin gan wrote: > > 1. I do have following database structure. > > users -> comment -> products > > a. users and products are the vertexes that contain some info etc: > user_name, product_name and .... b. comment is the edge that contains > comment and created/modified date. > > what is the sql query may look like in order to show the following result. > > Note: i have to show all of the products that may have or no have comment. > > 1. product_name, user_name, comment, comment_created_date, > comment_modified_date > 2. product_name, user_name, '', '', '' > 3. product_name, user_name, comment, comment_created_date, > comment_modified_date > > > ---------------------------------------------------------------------------------------------------------------------------------------------- > > > 2. what is the sql query to merge two classes (linked by reference) in > order to show the result of both classes in each row. > > for example. > > user have many pets (note: pets class will have link reference (user) to > user class). > > the outcome result should be as follows: > > 1. user.name, pets.name, pets.age >
anyone know this solution? -- --- 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.
