Is it possible to do a sub-select in a cross connection query? I built a cross query, and then went into the Query tab and added a sub-select statement, and it executed fine. But when I tried to save it I get the message saying “The diagram is not synchronized with the statement, please use Visualize Query button”. Once I do that, the sub-select statement gets deleted, and the SQL gets messed up.
So I’m thinking the diagram cannot handle the sub-select, but the query itself will run?