What are you specifically trying to join together?

Are you doing this inside of Sage using requesters, in 4GL or outside in an RDBMS for example?

Nick

Thank you Nick.

Nothing to join specifically. I am developing an application that describes the data model, like a class diagram. I use PHP, PDO SQL Server and a JavaScript library for the canva rendering.

I've got no issue to retrieve the tables, they're in the metamodel information_schema.

For the links between them, I was counting on foreign keys constraint type.

But there are none. Only primary and index types. So I guess Sage X3 uses its own table?