How to connect ORDR to ATC1

[docpinna]

Hi everyone, 

I am trying to create a query that allows me to link ORDR with ATC1. How can I proceed? I can't find any kind of connection and the results I have managed to obtain are never accurate.

Thanks to anyone who can offer some advice.

[RaymondGiuseppi]

Did you already try to join with ORDR.AtcEntry (or any Marketing Document table) and ATC1.AbsEntry ?

[docpinna]

Ive already try but it's impossible to connect the two tables with this key and I also can't find any common point with ORDR