BAQ "subquery" help

[knash (Ken Nash)]

Check out this post.

BAQ Challenge - How to convert this SQL with sub-selects (as Calc'd fields and where clauses) to a BAQ

@knash - You are the man. Thanks for that teaching moment, and I owe you drinks!! Will you be in Vegas? So, couple of things that I didn’t know/understand (for anyone else using this thread to solve a problem): Filter Value - using “value of subquery” option - I was trying to get it to go the other way, backwards, whatever you want to call it.I could never get my query to show in the query list. Using a Subquery (single column return data set) as an expression in a calculated …