/ Help centre
← All articles
End Users › General

Can I use an inner join with a multi level query in DataPA?

Applicable Versions: 3.02.0032 onwards From version 3.02.0032 onwards an inner join can be used in a multi level query in DataPA. To use an inner join instead of an outer join (which is the default behaviour) you must highlight the child subject in the tree and check the inner join box located…

Updated 26 March 2018

Applicable Versions: 3.02.0032 onwards 


From version 3.02.0032 onwards an inner join can be used in a multi level query in DataPA.


To use an inner join instead of an outer join (which is the default behaviour) you must highlight the child subject in the tree and check the inner join box located underneath the tree of subjects in the query wizard. This is shown below.


You must ensure that you upgrade the procedure library being used on the AppServers to implement this version.



Need a hand?

We’re here if you need a little more help.

Contact support ↗