Correlated Subquery only pulls matching records

[szumerspirit]

Hello,

I am trying to build a subquery/correlated subquery in Brio, where it returns all the parent records, with the child records only matching based on a specific limit. I cannot do this in the standard query based on the relationships.

I have tried both correlated subquery and a regular subquery but it keeps returning only records with matches in both tables like a simple join. I am not sure what I am missing.

Has anyone experienced this? I am on a very short deadline and am frantic. I would appreciate any advice.

I used the instructions here to build it:

http://businessintelligence.ittoolbox.com/documents/building-a-correlated-subquery-in-brio-18679

Thanks

 

[wesw]

Might help to see what you have for a query.