Two Tables link expression (Query Tool) Sage X3 v11

Dear All,

I need your support for link expression syntax ,Firstly I am looking for expression tutorials. let me to explain my issue as follows:

I have table  GACCCODE witch is Accounting codes table for example I've added field ACCCOD 

And I have anther table ITMMASTER witch contains field Products I need to link between these two table.

more over I need to create report using Query tool to give me a report as follows:

Accounting Codes ------> Products ---------> Account Type ---------------- SUDCOA 

   FXA                                                      Modifier | Purchasing                10211111

So please help me to solve these issues 

Regards,