Query Tool to export data from different tables in excel format

Question

Hi, 
 I am using query tool to look at the data in ITMMASTER, ITMSALES,ITMBPS and ITMBPC tables using EXCEL sheet. Below is the screen shot of the fields that I want to use to get the data. 
 
 But I keep receiving this error when I try to validate.

Could someone help me understand the Query tool and How to make it work please. 
 
 Thank you!

pnightingale · Answer

Hi Ramya, 
 Did you set up any links between the tables or selections under the Advanced tab? Syntax could be the issue. 
 For training on the query tools, Sage University offers the class Introduction to Requesters/Queries or check with your Sage business partner for training. .

Sage X3

Query Tool to export data from different tables in excel format

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING