Query Tool to export data from different tables in excel format

SUGGESTED

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!

Parents
  • 0

    Sometimes with this, I also find that adding new indexes to the tables help! if you need to link of fields that doesn't specifically match an index, none of the requestors like it (except SQL ofc where you create your own). The best fix seems to be to go create the indexes in the table definitions under development. 

Reply
  • 0

    Sometimes with this, I also find that adding new indexes to the tables help! if you need to link of fields that doesn't specifically match an index, none of the requestors like it (except SQL ofc where you create your own). The best fix seems to be to go create the indexes in the table definitions under development. 

Children
No Data