mend
Found workaround by using a Stored Procedure / Function to properly do the join (that filters by parameter).