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?

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report
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());

Was this reply helpful? Yes No