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.
- product_name, user_name, comment, comment_created_date, comment_modified_date
- product_name, user_name, '', '', ''
- 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: