orientdb sql query to select edge and vertex fields property.

246 views
Skip to first unread message

Martin gan

unread,
Feb 15, 2015, 10:42:52 PM2/15/15
to orient-...@googlegroups.com

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
Reply all
Reply to author
Forward
0 new messages