SQL query to get object names in Enterprise Architect diagram -

i want sql query list of object names in specific diagram of enterprise architect.

my target diagram_id 184

elements stored in t_object , diagram objects (the graphical representation of 1 element in 1 diagram) in t_diagramobjects. entry in t_diagramobjects has reference diagram (diagram_id) , element being displayed (object_id).

• t_object table: has columns object_id and name

• t_diagramobjects table: has columns object_id , diagram_id

if do:

select object_id t_diagramobjects diagram_id=184

i list of object_ids need names. want query involving t_object table names.

edit: rereading question, seems not know join.

here link (assuming sql server again): https://www.w3schools.com/sql/sql_join.asp

---

another edit

here more detail why normal join not work.

you can have ea project in form of local file or in database. when stored in local file, stored ms access database. ms access not support join keyword alone, need put either inner join, outer join, left join, right join...

and not know, can run sql queries in local file project creating new search sql query.

diagram objects represent visual elements see on diagrams. table t_object contains elements in repository, can make simple join object_id column.

this query should work on access database (.eap file) on sql server database:

select o.name t_object o inner join t_diagramobjects on do.object_id=o.object_id do.diagram_id=184