Asked a question 7 months ago

Hello, I have a current modeling (data model) that does not allow me, via the relationships between entities, to retrieve all the desired elements. I can clearly see the entities linked via a LEFT JOIN. However it would be necessary for me to be able to make RIGHT JOIN (impossible thing it seems to me in Semarchy). Question: I would therefore like to know if it is possible for me to create an SQL view (based on my Semarchy tables) in order to gather all the desired elements (green stars in the shared image) and display them in a table in Semarchy. If yes, how ? >Thank you


Aymen Ben RabahSEMARCHY TEAM
Customer Success Consultant at Semarchy

I suggest you go through a Dashboard that you will then integrate into your application.

In the Dashboard you can run any type of SQL query as you wish.

https://www.semarchy.com/doc/xdm/5.2.10/semdb.html#creating-a-query