orientdb sql query to select edge and vertex fields property.

[Martin gan]

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