Cross Company

(0) Share

Report

Posted on by CU01050835-0

Hi, If you have a SQL query with several joins like doing a while select on the salestable and salesline and you want the query to be cross company, do you need to use the cross company key word for both tables?

All responses (1)

Answers (1)

Verified answer

Martin Dráb 230,149 Most Valuable Professional on at

Like (1)

Report
Cross Company

Adding it just on the first data source will do.

Note that you can easily test it. Add generateOnly keyword to the query and run getSQLStatement() to get the actual SQL query. Then check if the SQL code looks as expected.

For example:

select generateOnly crossCompany purchTable join purchLine where purchLine.PurchId == purchTable.PurchId; info(purchTable.getSQLStatement());