Hi, I think te best is you use a SQL Query. In case you must use a Graphic Query, then create a  view and the use this view in the grphical query. Any way you must take care about the indexes in all tables you are going  to join to take care about DDBB performance. 

This hels you? 

thank you i'll try 

Hi Emanuel. My approach to these complex queries is the same as Xavier. You are linking a few heavy tables, so database performance can degrade a bit along time. I usually write a view either on x3 or direct in sql, that view has all the joins and preprocesses any information i need, and that sits on the database side, so its very fast. Then i do a sql query or graphical query to list that view with the parameters i need. 

Like this any data is ready on the database side and running the sql query is just bringing in the data across.

Good luck with your query. Buzz if you need any help.